As per the attached screenshot, I need a formula to derive user with a blank cell to be shown as pending. (Pending has been manually entered.)
Asked
Active
Viewed 32 times
0
-
Welcome to Superuser! What formula have you tried? – Reddy Lutonadio Jan 25 '23 at 12:43
-
just filter the data, or use `filter()` – gns100 Jan 25 '23 at 16:22
-
Data from Column F to N is in different excel sheet. – Kazim H Jan 31 '23 at 13:18