Forum Discussion
Excel Formula to find and place Unique Value, calculate days between the first entry and last entry
In the table below I require to find formula to fill out column C and D, since I have thousand of records to filter through COLUMN A has duplicate ID which I need to identify the distinct ID in CO...
mathetes Thanks Mathetes. the suggested formula did not work; the result of the formula was 0.
Also looking for a formula for D3 to compute the number of days between the first date for the ID and last date for the same ID.
I attached spreadsheets in both cases that DID work. I just posted the formula to make the posting more educational.
The second example, using UNIQUE, will not work, as I said, unless you have the newest versions of Excel.