robert

Hello all, I have shared two tables below, first one is a DATA SOURCE and second one is the DESIRED RESULT. I want the DESIRED RESULT in yellow highlighted columns in the 2nd table. I am looking for a particular formula which can read and match the product ID from DATA SOURCE and distribute...

Apologies for the newb question, im very much beginner level excel. I'm trying to find a value in column A where there at least 2 of that same name and find the higher number of those two matched names. I also want to return the name of the agent that ties to the higher value in column C. i.e. I...

I am looking to setup a formula to be able to search multiple columns (4-5) of names and if there are any duplicates to export them to those cells. I am sure that it is easy but formulas I have been using shows the first duplicate and then the same one again in the next cell and if possible I...

Hi, I am trying to get all the values from rows with VLOOKUP. I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons... <tbody> Seller Product Adam Bananas Oranges Lemons Robert Apricotes Lemons...

Can the following formula be amended so that the answer to any query is exact to the query input? =IF(ISBLANK($Q$2), 0,SEARCH($Q$2,$C10&$D10&$E10&$F10&$G10&$H10)) Robert

Hello, I have Customers list that start in cell B4 that looks like this: Bob John Andy Robert And I have a Products list that start in cell D3 and looks like this: Sony PS XBOX My want to create a forumlas (i gess an array formulas) that create this table: Product | Customer Sony PS...

Dear Mr. Excel: I am a schoolteacher who is trying to create a multiple-choice auto grader. However, I am having difficulty created a nested function. Can you let me know what is wrong with the following?: =IF(ISBLANK(E10),"",ISNUMBER(SEARCH("B",E10)),"1","0") Sincerely, Robert McLeod

Hello. I have been looking for an answer but obviously it is hard to find a case exactly like mine and I dont have the technical nous to change anything without screwing it up. If you can help I will be very grateful. I get an auto-generated spreadsheet from a software. This is a sales...

Ive got a nice spreadsheet set up with all the info I need, but I cant get the formulas to tie together correctly to calculate properly. Im getting very frustrated! Please help. :confused: Why cant we attach excel here?!?! <colgroup><col><col><col><col><col span="3"><col span="3"><col><col...

hi all.. i know this has been done to death.. and even by me... however hoping for a solution... I have this table; <colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody> Client Staff Member a max b robert c charles d charles e charles f robert g robert...

I am trying to find a way to put this information from a report into an easily readable table. I want to look for the name of a person in Column A, once I find the name I need to find the next instance of "Time" in Column B. The Final Result I need comes from Column C. So on a Separate sheet I...

In ColumnA I have sentences wrapped and in columnB list of words formula should lookup range of words in columnA and get 4 words including matched word. for example. Robert is honored in computer science and Robert earned GPA 3.6 and he has a bachelors degree (ColumnA) 3.5 (ColumnB Range) 3.6...

Greetings! I was unable to find anything similar to my issue and been banging my head on this all day. I have a table with multiple columns of training information. I need to figure a first time pass rate for each course by each individual. I do have a unique PSID for each employee, a unique...

Hello everyone, I have been using the below macro to calculate the number of permutations (output columns C onward) for a list (input column A) based on the number chosen (input column B). However, I now have a list that is further broken down by groupings. My goal is to be able to input this...

Hi, How to sum say(A's Score) for a said date say Today(16/1/2012) Name Date Score a 30-Apr-11 2 b 1-Jul-11 4 c 14-Jul-11 3 a 8-Dec-11 4 a 22-Jun-11 2 b 30-Nov-11 1 b 15-Sep-11 1 c 12-Nov-11 4 a 2-Nov-11 5 a 10-Oct-11 6 b 9-Nov-11 6 a 21-Oct-11 2 Thnks in advance