paul

  1. J

    VBA Code to find max value from horizontal text from list having numbers

    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...
  2. P

    Difference between 2 values

    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...
  3. A

    Automated ranking board

    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...
  4. T

    Help IF function bug

    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...
  5. M

    vlook up help request

    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...
  6. W

    Vlookup multiple values for multiple results

    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...
  7. B

    vlookup question using more than on variable

    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...
  8. C

    Something weird going on

    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
  9. CyrusTheVirus

    I'll admit it... I'm stumped!! Need hierarchy help.

    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...
  10. G

    Assistance with Excel Index's

    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...
  11. M

    Accrual VS. Usage Formula

    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...
  12. S

    PowerPivot - Searching Between Tables

    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...
  13. P

    two identical names in different columns in Excel

    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
  14. Sean15

    Want to return unique value for each duplicate

    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...
  15. B

    VLookup formula to extract data based on row and columns

    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...
  16. S

    Generate lists from array

    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...
  17. S

    Extract cells from one sheet to another based on specific criteria

    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...
  18. H

    How to make If, Sumif Function Formula shorter

    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...
  19. C

    Coulkd someone help me correct this please?

    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...
  20. M

    Web based SS

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top