richard

Hi Everyone, Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance! Below are my sample data and desired result <tbody> Employee ID Sales Person Sales <tbody> S00001 S00002 S00003 S00004 S00005 S00006 S00007 S00008 S00009 S00010...

God morning folks, I have the following table: <colgroup><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Job holder Title Forename Surname Known As Pickford, Mr Leighton Mr Leighton Pickford Baines-Gueye, Mr Richard Mr Richard...

Hi Great Master of Excel, Id like to seek help on how i can make this possible. I need YES or NO to appear on a Cell if the Name is found under opened by using the list on column A I tried conditional formatting but i couldn't seem to get it. Thank you Ralph YES/NO Number Opened by...

I have this and I need to get the first and last name out so I can use them for a vlookup please help Richard XXXXXX 1993446666 Tom XXXXXXX 1993444444 I am using this =RIGHT(G7,SEARCH("",G7,10)) but I need to use the name now

Hi, I have data on seven worksheets, examples below: <colgroup><col><col><col span="2"></colgroup><tbody> Worksheet 1 Name Contact number Quantity Company Richard 1234 10000 Amazon Mike 2345 5000 Amazon Michael 5678 3000 Amazon Nancy 4567 5000 Amazon Alpha 6789 8000 Amazon Bravo...

hi all I have a string of numbers 123456,but sometimes there could be a letter in there i.e 123x56,12345x.what I wont to do is sum up the last three numbers. I have this formula which works ok till a letter comes along =IFERROR(SUMPRODUCT(--MID(AB8,ROW(INDIRECT("1:" & LEN(AB8))),1)),"").I have...