paul

Hi Experts, Need some help with putting this function together for my macro... =ISNUMBER(SEARCH(VLOOKUP #1 I need to VLOOKUP the Customer ID ("Z") in "AirportCodes" sheet #2 Once found (i.e. EWR) I need to use the User Defined Destination ("AA" - Sheet1) and see if it exists in any of the...

Hi all. I have a large data set where I am trying to determine which people worked on specific days. However, there are some instances where multiple people worked on the same day, so I am getting a double count; I only want to count it once. I have 1000 rows of data and I've provided some...

I have the following data: I would like to use sumproduct based on day of the week but also replacing the Hi, Mid and Lo with their correct values. For example, for Paul, the total of his Mondays, should be 1*100+3*1+1*1 Any ideas?

Hi I am running s2member on a Wordpress site it records checkbox data like this for example a:2:{i:0;s:15:"NW2";i:1;s:13:"NW3";} s2member can export as a CSV file Can this data be used in excel? Or can the values be extracted from the data between the quotes i.e. NW2. NW3 Thankyou Paul M

Hi everyone I have a list of scores for students along with year group they are studying in. <tbody> Name Points Year John 100 7 Paul 252 8 George 800 8 Ringo 53 7 </tbody> I would like to create a leader board for the Top 10 in each year group based on these scores. Year 7 <tbody>...

Hi all, i have data and i want some results automatically in a specific cell kindly help me i am posting an example of data here. <tbody> Target achievers name target achieved date i want here when i enter name of target achiever i.e Result column Paul 12-9-2017 Paul all of dates on which Paul...

Hello there! A couple of months not touching Excel seem to have dried my brain out and I'm out of ideas. I have this type of schedule table for around 60 ppl that extends throughout the year. <tbody> 01/01/18 02/01/18 03/01/18 04/01/18 John A B OFF OFF Paul A1 B1 A B George B A OFF...

Hello, I need a bit of help with the next situation: There are two columns, in the first (A) there are two names(PAUL and JOHN) inserted from cell A2 till cell A16, in the second column there are hours. How can i return the first five values(hours) corresponding to JOHN? <tbody> NAME HOUR...