Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - to accumulate the number of data appear
Hi
i got some problem with excel. My 1st spreadsheet - No of appointment Date Status Country -------------------------------------------------------------------- 01-09-2006 Accepted ABC 01-09-2006 Accepted ABC 01-09-2006 Accepted ABC 01-09-2006 Accepted 123 01-09-2006 Accepted ABC 02-09-2006 Accepted ABC 02-09-2006 Accepted ABC My 2nd spread sheet Country Update ABC 01-09-06 02-09-06 Appointment 4 Tis are roughly my spreadsheet , how am i able to count the number of appointment on the 01-09-06 and computed on those the 2nd spreadsheet that particular cell ?? Thank alot for the help . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
formula won't work unless column of data is a hard number | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |