james

Hi folks, Trying to do a simple hyperlink so I can link to the first error value in the range. Formula is {HYPERLINK("#"&CELL("address",MATCH(TRUE,ISERROR(range),0)))} I keep getting the "we found a problem with this formula..." pop up. Seems to be the "#"&CELL("address"... portion, which...

Hello Folks, In My Work Book I have: James Brown Han Solo Luke Skywalker I need a formula that will make it : Brown, James Solo, Han Skywalker, Luke Your thought please and Thank you in advance

I have a column of data with no particular structure to the characters. They are notes containing combinations of dates, model numbers ect... I'd like to find just the strings of 10+ numbers. Sometimes the numbers are consecutive, sometimes separated by a "-", "/" or " ". Below is an example of...

<tbody> name dept week 1 week 2 week 3 john a 30 30 25 james a 30 30 30 james b 20 - 10 queen b 30 30 30 </tbody> imagine a much more larger data set with more names, weeks. how do you identify the names that worked more than 30 hrs in any week?

I was creating a unique id for a column and wanted to concatenate the ascii numeric representations for the letters to the end of an existing id in powerquery. Such as in this example <tbody style="box-sizing: border-box;"> trainernumber trainer_track Name working out answer_id 81483...

Hi, I am trying to learn how to use index match function when there is multiple variables. I am getting NA error below is the screen shot can somebody explain where i am going wrong and what i need to be careful when i am using the formula. I am using ctrl+shift+enter to sun this formuls...

I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137. I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it...

Hello, I have a huge excel where the first and last names in a cell are like this : JAMES SMITH. Could you help me please with a formula so I can have James SMITH? Thank you in advance

Hi, is there an easy way to extract a name from the following string? The string has the following format. I just want James Bond out of this string. James Bond J. Bond

Hi Everyone! I'm working on a spreadsheet where everyone's work hours are tied to the project he or she is working on. For example, I have the name of the person in Column D, and Column R is the hours billed to the job. The hours billed to the job comes from a list at the bottom of the...

Howdy- I'm needing some help with something i'm not sure how to do. I have a 2 cells (text values) that has names (i.e. Bob and James), i am needing a way to have these values swap each week for example. If this week E5 is Bob and C7 is James, i need for it to next week automatically switch to...

I am trying to add onto a current VBA script to do the following: The name itself and the number of names will be different each time the script is ran. Before <tbody> Name Animal Mike Elephant Mike Dragon Mike Dog Mike Cat Mike Mourse Mike Bird Mike Hawk April Lion April...

wasn't sure what to title this. If i have data as such <tbody> Name Score Ian 1 Ian 2 Ian 3 Ian 4 James 1 James 2 James 3 James 4 John 1 </tbody> What I want to see is this <tbody> Name Score 1 Score 2 Score 3 Score 4 Score 5 Ian 1 2 3 4 James 1 2 3 4 5 John 1...

im trying to get yes or no if a certain cell contains the words own goal ? heres my prob in E608 ih have the words Own Goal James Russell this is what is use to use =IF(E608="Own goal","Yes","No") this would return yes if only it contained Own goal but now that ive added the own goal scorer...

Dear All, I do have a sample data-set across A1:F6 as follows:- <tbody> Region Vendor Name String Lead Time PO Count % Mix-PO Count Desired Result North James Associate NorthJames Associate 2 4 20% North James Associate NorthJames Associate 4 10 50% 4 North James Associate NorthJames...

Hi Gurus, <tbody> Emp name father name mother name Guardian name James XXX XXX XXX david XXX </tbody> i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement...

A B C D E F G H I 1 Players 1 2 3 4 Total pts Sets Won Rank 2 1 john X 2 1 2 5 9 3 2 james 1 X 1 2 4 5 4 3 mathew 2 2 X 1 5 5 5 4 ace 1 1 2...

Raw Data below: I need to create a report that shows: Till ID, Sales Person and Time of first sale. I have used MID to extract the till number and then used IF(AND ..... If till number = 1629 and Column C = sales then return time in column B but this has failed miserably. I want to show that...

Hello: I have a list with duplicates and unique names. How can I mark each duplicate and unique name with "1" For example: John James 1 John James Peter Floyd 1 Mike Sutton 1 Mike Sutton My goal is get total head count that should not include duplicates. Thanks for your help. Sean

Hi everyone I have an attendance sheet(around 200 empls) in table 01 format and i need the same in table 02 format. Tried sumproduct, sumifs and getting errors. Table:01(current) <tbody>#888888[/URL] "] #FFFFFF[/URL] ]E #FFFFFF[/URL] ]F #FFFFFF[/URL] ]G #FFFFFF[/URL] ]H...