david

<tbody> Antriksh David David Antriksh </tbody> how do i use index and match to find the results for the duplicate values? i am getting duplicate result for the second "Antriksh". let me know if this is possible.

Hi, I have a sheet for users to fill, first column A must be filled, after that they can fill any other columns in the row. How do I ensure column A is not empty? Thanks for any help David

Mr.Excel Experts, I have a spreadsheet of goals for individual sales reps that i need to put into a simple goal workbook for each rep. Is there a way to auto populate the data? or do i need to manually do each one? There is a total of 36 reps. Thanks, David

Greetings and salutations oh great gurus of all things EXCEL!! I need a formula to return a person's name with from the below example after using "CATEGORY" and "DIVISION" to quantify. For instance, if I enter BEER and FLBU, I would expect it to return Paul Oderio as the name. Any suggestions...

Hello All, how can I convert multi rows data into single row using power query.. My above column must look like the below comlumn.. Thanks.. <tbody> Driver Name Driver ID Bus Number School ID School Name Timing David 1005 F5002 A123 Helen Model School 7:15 David 1005 F5002 A300 Stuart High...

I want cell J25 to count following cells as 1, regardless what number is in the cell. I8:R8 I11:R11 I14:R14 I17:R17 I20:R20 Thanks in advance!!! David

Hi All, I have a "Summary" tab that records a list of subject in column B2 onwards, in Column C1-E1 there are heading with peoples names that relate to my three sub tabs, the sub are named "David," "Mike" and "Susan". So in C2 of the "Summary" tab, I want to look at the subject in column B...

Hello. I have a table with 4 columns A B C D. The table represents names of students (column A), and three desired friends in class (columns B,C,D). For each student, I would like to color in blue cells of friends who are with him in class, and in red friends who are not with him in class. Can...

Hello Everyone, so i have in my sheet a row with dates and another row with names, the names are shown several times in different dates, I want to show in other place in the sheet (a few rows under..) the name and next to every name the last date it was written so for example if Jim was...