| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Matching two cells
Hi, I'm trying to get Excel to match information in two different columns and add the number of occurances, but unsure of how to do it.
Below I have listed 4 columns of information; I need to match for instance the number of times that in the first cell "06:15" matches the last cell "GAZ" and add the number of times this occurs, in the example it occurs "2" Anyone that can help please? 06:15 14:45 08:30 GAZ 08:00 16:30 08:30 GEORGIA 09:00 17:30 08:30 CLAIRE 11:45 20:15 08:30 KERRY 13:45 22:15 08:30 HELEN 06:15 14:45 08:30 CLAIRE 10:00 18:30 08:30 KERRY 13:45 22:15 08:30 GAZ 17:00 22:00 05:00 PAULA 08:00 16:30 08:30 GEORGIA 08:00 16:30 08:30 HELEN 12:00 20:30 08:30 KERRY 13:45 22:15 08:30 CLAIRE 17:00 22:00 05:00 PAULA 06:15 14:45 08:30 GAZ 10:00 18:30 08:30 HELEN 13:45 22:15 08:30 CLAIRE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Matching cells that have unrelated information | Excel Discussion (Misc queries) | |||
| Matching cells | Excel Discussion (Misc queries) | |||
Threaded Mode
