« Data Range Properties Options
Windows Noise »

New Excel Blog

April 26, 2004, 1:04 pm by Dick Kusleika

Andrew’s Excel Tips is a new Excel blog. Andrew is a self-proclaimed intermediate user, but will soon be an expert. You can’t write a post a day about Excel and not learn something. Keep it up, Andrew.

Category: Weblogs  |  Comment (RSS)

4 Comments

  1. Andrew says:
    April 27, 2004 at 4:11 am

    Dick, Thanks for the nice post. It’s an honor and I truly appreciate it.

    I’ll have to do my best to become a real expert now. Lots and lots of study ahead.

    Andrew

  2. Colo says:
    April 27, 2004 at 6:08 am

    Andrew. you have done a marvelous job so far. Carry on! ;-)

  3. ram says:
    January 12, 2006 at 9:15 am

    Hi Andrew

    I have a question I have a data for about a year where in I have entry of customers who come in at different time of a day,I have it sorted for the entire month and I am trying to calculate the total number of arrivals that occur in a particular hour through out the month so I can come up with an arrival rate for a day based all the data I have.

    For ex:

    G.W.Bush 1/12/05 10:27 (in)
    Clinton 1/12/05 10:30 (in)
    John Kerry 1/12/05 10:35 (in)

    Rice 1/12/05 11:00 (in)
    Agassi 1/12/05 11:15 (in)
    Sampras 1/12/05 11:35 (in)

    from the data you can see there were 3 people who arrived b/w 10-11 and 3 b/w 11-12 like that I have data for the whole day and whole month sorted by day and time. so I just want tocalculate the total number of arrival in 24 hour period for the entire month.

    Hope you could be of help to my question.

    thanks!
    Ram.

  4. Jim says:
    March 30, 2006 at 4:09 pm

    I’m trying to use the ‘lookup’ function to return the required value or the next LARGEST value. From what I’ve read, it’ll only return the required value or the next smaller value.

    Ex.

    I want it to find the value at or greater than 2.2 and here’s my data:

    1
    2
    2.5
    3

    If I used ‘lookup’ it’ll return a value of ‘2′ when I want it to return a value of ‘2.5′.

    Thanks

    Jim

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a Reply