You enter it into B2, then you grab the little black box in the bottom right of the cell and drag it to the right to copy the formula to the other cells in the row.I just entered the formula into B2 to get the result I got.
You enter it into B2, then you grab the little black box in the bottom right of the cell and drag it to the right to copy the formula to the other cells in the row.I just entered the formula into B2 to get the result I got.
Last edited by AliGW; 07-21-2019 at 02:43 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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I uploaded a file. It works but the correct info is in the 2nd, 4th, 6th column dragged across to. If you don't want to fix it I can work with it anyway![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks