similar

  1. P

    Return Header if specified row contains a value

    I have a data set that looks like this: A B C D E F P 2 0 2 0 0 3 Q 0 3 1 1 1 0 R 6 0 0 0 1 0 S 0 5 0 3 0 0 T 0 0 5 0 0 2 U 0 0 7 0 0 0 I need to be able to search that table by putting selecting an input value from P-Q then if that selected row has a value greater than 0. I need it to...
  2. J

    Similar functionality as SUMIF

    Sheet 1: is set up as follows with ACCOUNT is cell A1.. I have other accounts following 610200 going down from A2 to A59 with the description and amounts as seen below in other cells. <colgroup><col width="106" style="width:80pt"> <col width="189" style="width:142pt"> <col width="80"...
  3. M

    PowerPivot similar software

    Hey guys, i usually work with a lot of data both in quantity and file size. Yet sometimes i have to make a LOT of calculations in order to get result. Like, one time i had a Pivot from PowerPivot data that had around 1 million calculations. So i was wondering if you knew software, similar to...
  4. L

    Identifying Variant or Simialr Text Entry in One Column

    Hi everyone, I've been struggling with this one for some time and I thought I'd throw it out there to see if anyone has experience of solving this type of problem? Sorry if its already been covered, I have looked and can't find anything quite like it. The problem I have is I have large...
  5. C

    Automatic cell references based on similar text values in adjacent column

    Hi, I have a large database resembling the image below, with instances of similar text values in one column and a corresponding numerical column next to it. I am trying to modify the numerical column such that when I edit one numerical cell, all cells in the same column with similar (not...
  6. E

    Copy cell to a new sheet on same place

    Hi guys Could someone help me, I use this the variable: FindCol_RowID="sv" (that is the search string the script looking for in a sheet) then in the msgbox I get the ID of the cell but could someone help me to paste the cell + column into a new sheet on the same place? See code below...
  7. E

    If function finding similar cell

    hello, i want to write a logical function assuming in C2, for lets say if another cell in column A (i have about five thousands rows) is same as A2 and the cell in B column belonging to same row as that one is not blank, then c2 shows "full" otherwise "blank" would very much appreciate any...
  8. S

    clear contents if cells are equal except first

    I am try to format a report so it is simpler to read. Right now I export information from Access. The product names are repetitive and I want to use them as titles, so I want to keep the first title then delete all the similar ones underneath it. Right now my data looks similar to this when...
  9. I

    [Grouping Data] Moving Into One Row

    Hi there! I have a list of data, many with a similar data code. As a result, I'd like to group the datas with the similar data code. Here's an example: <STYLE type=text/css> table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;}...
  10. S

    Macro to add rows having cells of similar data

    Hi All, I am a beginner in Macro coding. And I would like to know how the following can be done using macro.Could someone help me with this ? <TABLE style="WIDTH: 632pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=843 border=0><COLGROUP><COL style="WIDTH: 62pt...
  11. E

    Identifying misspelled names?

    I have a column of names in one workbook, and a column in another workbook. Some of the names in the first workbook are misspelled. For example: Jesse (workbook1) vs. Jessie (workbook2) Madelynne (workbook1) vs. Madeline (workbook2) I am trying to use a function that can look at the names in...
  12. B

    VLOOKUP - Lookup value slightly different to values in lookup table

    Hi All! I am currently having trouble using a VLOOKUP function. The reason I have a problem is my Lookup values are slightly different to how they appear in the lookup table, but they are similar. They are in fact serial numbers, but the two data export files I am using (annoyingly!) display...
  13. R

    Averaging numbers from similar names

    I have tried looking for similar questions in the forum and couldn't find them. If you know of any, please let me know. My problem is that in one column I have peoples names that are repeated. I need to average numbers that are in the same row as their name. So for example: <TABLE...
  14. C

    Sorting information?

    This is my second posting. You guys helped me out of a REALLY tight jam last time and I appreciate it like you'll never know. I have another question. I have a list of repairs that my company has done (32000 + items). There are several part #'s entered by several different people. Each person...

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