Hi,
I would like a formula which lists unique entries based on three columns (C,D and J) and if unique I would like a “1” placed in column S.
To give a bit of background this is timesheet submissions. Currently it details all line items of submissions e.g. I worked 50% on contract A and 50% on contract B. I would only need to know one timesheet was submitted.
Can anyone help please?
I have included example data.
Would I be correct to assume that you want to identify the first occurrence? If so this formula in S4 and down will duplicate the values in the sample attached to post #1:Let me know if you have any questions.Formula:
Please Login or Register to view this content.
Last edited by JeteMc; 08-15-2016 at 10:23 AM.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi
Thanks - you were correct to assume! The formula you supplied worked
You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks