I've been trying for half hour to get numbers to count the number of cells in another sheet that match the same cell in my other sheet.
Basically:
SHEET 1: Table 1
Name - address - Number of Orders etc
Name1 - Address1 -
SHEET 2: Table 1
Name - order info etc
Name1 - orderinfo1
Name1 - orderinfo1
Name2 - ETC
I'm trying to get sheet 1: table 1 to give me a number of times Name1 occurs in Sheet 2: table. So sheet 1 can basically keep records of how many orders that person has.
Hope that makes sense.
Tried google, searched the user manual and can't find a thread anywhere or an answer anywhere. Little help?
Thanks
Basically:
SHEET 1: Table 1
Name - address - Number of Orders etc
Name1 - Address1 -
SHEET 2: Table 1
Name - order info etc
Name1 - orderinfo1
Name1 - orderinfo1
Name2 - ETC
I'm trying to get sheet 1: table 1 to give me a number of times Name1 occurs in Sheet 2: table. So sheet 1 can basically keep records of how many orders that person has.
Hope that makes sense.
Tried google, searched the user manual and can't find a thread anywhere or an answer anywhere. Little help?
Thanks