Wed 3 Jan 2007, 16:42Delegate Lisa said...
Lisa has attended:
Excel Advanced course
Access Introduction course
Look Up and Compare Data In A Column
Which function do you use to look up a range of entries and determine whether the same text / number appears in that range and identify how many times it appears?
Thu 4 Jan 2007, 21:52Trainer Tom said...
RE: Look Up and Compare Data In A Column
Hi Lisa,
Thank you for your question. You would be requiring the COUNTIF Function with the following arguements: =COUNTIF(Range,Criteria)
eg Range A2:A10 contains repeating values for regions in a transaction list, you want to know how many purchases in North region.
=COUNTIF(A2:A10,"North")
Hope this helps
Regards
BEST Training
Feel free to recommend the forum o amliy, friends & collegues
