| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
match and count words
Is there a formula I can use to match a file name in one column with any
matches in other columns and give a total count for each column? Example: A B C D E F 05l.jpg 106.jpg 543.gif 106.jpg 37l.jpg 106.jpg= 0 in column A, 1 in column B, 1 in column C, 2 in column D etc etc€¦ 12l.jpg 246.jpg 106.jpg 112.jpg 002.bmp 107.jpg= 0 in column A, 0 in column B, 1 in column C, 0 in column D etc etc€¦ 37l.jpg 1141.jpg 413.gif 37l.jpg 1141.jpg 109.jpg= 0 in column A, 0 in column B, 1 in column C, 0 in column D etc etc€¦ 69l.jpg 351.jpg 107.gif 002.bmp 084.bmp 112.jpg= etc. etc€¦ 35l.jpg 112.jpg 109.jpg 106.jpg 124.bmp 1141.jpg= etc. etc... Any suggestions, ideas would be greatly appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| If two columns match then count one. How? Tried countif and sum . | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| lookup, count | Excel Worksheet Functions | |||
Threaded Mode
