Hello,
Can someone please see why my driver list on the Driver Pay sheet cells E2:E11 is missing Driver 6?
Thank you
Hello,
Can someone please see why my driver list on the Driver Pay sheet cells E2:E11 is missing Driver 6?
Thank you
There is no error, so the formula does not move to the IFERROR value (formula). The first formula returns blank.
Last edited by AliGW; 02-06-2020 at 09:00 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The formula is supposed to have all drivers but it is leaving out Driver 6. Maybe there needs to be a different formula?
Thank you
Yes, I know, and I explained why in post #2. Yes, you will need a different approach.
This regular formula might get you partway there:
=IFERROR(LOOKUP(2, 1/(COUNTIF($E$1:E1,$D$14:$D$18)=0), $D$14:$D$18), LOOKUP(2, 1/(COUNTIF($E$1:E1, $E$14:$E$18)=0), $E$14:$E$18))
Thank you for your help.
I did find this formula and it does include all drivers but it doesn't have the list tidy without blanks in some of the cells in the range E2:E11.
In fact it is recognizing "0" as a driver. Maybe it can be edited:
Formula:Please Login or Register to view this content.
I have tried many different ways perhaps this is hopeless.
Sorry for the bother.
I figured it out by altering my formulas in the below data to not show any zero results.
I appreciate the help
Eddie - please understand that there is no 'bother' - why do you keep saying this? We are here to help, however if that help does not materialise within 20 minutes, it does not mean that people are unwilling to help, it's just that there is nobody available to deal with it right at that moment.
I am glad you found a solution - thank you for sharing it.
Last edited by AliGW; 02-06-2020 at 12:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks