paul

Dear All, I have the following names in a row like below <tbody> #FFFFFF[/URL] "]Sam #FFFFFF[/URL] "]John #FFFFFF[/URL] "]Jack #FFFFFF[/URL] "]George Paul #FFFFFF[/URL] "]Mathew Joy </tbody> and I have a table on another sheet where I have the following data, <!-- Please do not...

Hi all, Here is a sample of a spreadsheet (horse racing). A B C D E F G <tbody> 13:35 Lismore 2 2 Flag Raiser 73.60 1 13:35 Lismore 2 1 Game Set Match 64.46 2 13:50 Goulburn 2 1...

Hello guys, I hope you can help. I have a sheet that basically has names and scores, the names are in cells B3-B10 and their scores are in cells Z3-Z10. This is part of a scoreboard with other bits in between them so everything needs to stay where it is, however I would like to put a live 1st...

Hi guys, First of all, thank you for all the content you can find on this site and for the help you provide. I publish today because recently I have a unexplainable problem on excel: For 1 month, I have been working on a file where I mainly use IF / Large Functions. My formulas worked very...

Hi, I'm trying to complete a vlookup formula, but doesn't seem to be returning the correct info I have two sheets. Sheet one cell A1 is where i would like to have the Code returned from sheet two. I've tried looking for the names, then returns the code against the name in sheet 1. but I'm...

Hi everyone, I have a specific issue i cannot find my way around it.. In cell A1 i have numbers: 357 359 431 452 576 589 In the other sheet i have numbers and names in 2 columns, numbers in A, names in B 351 353 355 357 mario 431 433 435 437 ivan 100 102 104 106 paul Which formula can i use...

hi all need some help please. in column 'A' I have a list of numbers with multiple duplicates. in column 'b' I have a list of names, in column 'c' I have a list of colours. <colgroup><col width="72" style="width: 54pt;" span="3"> <tbody> A B C 1 dave yellow 1 dave...

Hi. On a previously created worksheet I enter a value of 50 into A1 and press return The value appears in C1 as if A1 to D1 have been merged and centred There is no formula in C1 and no obvious formatting in A1 Does anyone know how Excel does this? Paul

This is the first time in my professional career that I am unable to figure out how to use features/formulas (i've never needed VBA, until maybe now) in order to solve a problem. Basically i need to create a certain formatted hierarchical structure based on the below table. I need each...

Hi All, I was wondering if anyone could help me, i have a list of people, and payments. for example : <colgroup><col><col></colgroup><tbody> Eddie 10 Steve 12 Steve 65 Steve 12 Steve 12 Steve 35 Steve 56 James 66 James 73 James 21 James 33 James 21 James 21 James...

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'm new to PowerPivot and running into an issue with searching between 2 tables. I setup 2 tables in PowerPivot and created a relationship between them. I am trying to count the number of instances a user shows up in a specific column. The column may contain several users within the...

Hi all, I have a simple spreadsheet where in two of the colums have names in them. Column E and column L. A certain name may appear just the once in both of the columns, no more than once. I want to highlight/find the names that appear in both columns? Any suggestions please Paul

Excel 2010CDE3John Paul12.504John Paul10.505John Paul11.506John Paul9.507John Paul8.758John Paul4.509Mike15.7510John C Paul7.5011121314John Paul12.5015John Paul10.5016John C Paul9.5017John Paul8.7518John Paul4.5019John Paul#NUM!20Mike15.75single lookup valueCell...

Good day, I’m not sure if vlookup is the right way to go, but this is all I really know. I am open to any suggestions to the following: I have 2 sheets in my excel woorkwork: Sheet one has the following data: A2: Date B2: Race C2: LICNO D2: NAME E2: SURNAME F2: SEX G2: AGE H2: CAT I2: HMS...

Hi, new user here who's not bad at Excel, but doesn't have a lot of experience with arrays. My problem: Given a list of groups (in this example types of fruit) and membership in each group (names), I'd like to generate a rows where each person's group memberships are listed. <tbody> A B C D...

I have a large amount of unique values that are categorized under 3 names in one sheet. In separate sheets I want to be able to pull out the values by each name without skipping a row. See below. In the example below is what I have in Sheet 1 on the left - all unique values under 3 names. In...

Hello, I have a formula on one Sheet that looks in row B4:Q4 on another Sheet, for the cell If it equals the string "KG" then it Sumifs that Range of Rows 5:1000 for the criteria range in A5:A1000 and criteria in A2: e.g. If H4 = "KG" then Sumifs range:A5:A1000 criteria: A2 sum_range: H5:H1000...

I'm trying to modify this field which currently gives a positive result if over or = to 3, then minus 2%. I want it to give a positive result for 3 or over, and equal if exactly 2 with no minus 2%. =IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,-M5)) I would be really grateful for assistance as...

I'm not sure if this is possible to do and reading what I have found so far makes me feel like it isn't but I have to ask anyway. I have a very simple pricing spreadsheet that I would like to put online on my site for clients to use. Is it possible to place a usable spreadsheet on a webpage and...