Formula for repeating cells

[anthonator]

Hey guys. In column a I have a bunch of dates. Some of them repeat. I’m column b I have a bunch of text. I want to pull the number of times a specific word
Appears in column b the first time it corresponds with a date. So if column a was 10/1/18 and 10/1/18 and column b was test and test, it would only count it once. Is there a single formula for that?

[FDibbins]

Take a look at using the COUNTIFS() function

Something like...
=countifs($A$2:A2,A2,$B$2:B2,B2)-1

[anthonator]

Thanks FDibbins. I don't think I understand that one. Do you think you could suggest something using the following terms. Lets say the text im trying to count in Column B is "Test". If I pull every row with the word "test" in column B, Column A will have a bunch of dates, but some of the dates repeat. So I only want to count those dates once. So I want to count the number of times "Test" is in column B with a unique date in Column A. Thanks in advance!

[azumi]

Just try upload your excel file and your expected results

[FDibbins]

I agree with azumi, to best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.