Ignore Duplicate Entry in Formula

[ExcelRoy]

Hi,

I am trying to work out if the following formula could ignore a duplicate entry when returning the relevant number

=IF(G12="","",IF(S12="Monday",7.5,IF(S12="Tuesday",7.5,IF(S12="Wednesday",7.5,IF(S12="Thursday",7.5,IF(S12="Friday",7,IF(S12="Saturday",0,IF(S12="Sunday",0))))))))

if there is a duplicate entry (Which could be possible) i need the formula to return only 1 result and not 2

Is this possible?

Thanks

 

[James006]

Hi,

Sorry but you say "duplicate entry" what do you mean ... in which cell ? how can you have a duplicate entry in a given cell ?

 

[ExcelRoy]

Yes not very clear sorry

So this formula returns the number relating to a particular day from S12 (Date format 03/04/23)
Now my issue is if there is 2 entries against the same date then the formula above will return 7.5 for each entry
Can the formula be adapted to only display the first entry

Thanks

 

[ExcelRoy]

Just to add i am trying to work out overtime on a timesheet but based on minimum hours worked

 

[James006]

Sadly a formula cannot "guess" it has already dealt once with the same date ...

If you do carry Duplicates ... is there a valid for you not to get rid of them ???

 

[ExcelRoy]

Not really as the user may enter different lines per day entry

I'll have to think of a way around the issue, but thanks

 

[James006]

Understand the User might enter several times the same info ...

But does it prevent you from cleaning his input ???