value match

  1. S

    Copy cells from specific row if the value from another cells match

    Hi guys, I have a problem with my accounting data analysis. I have two workbooks, let's call them "MAIN" and "DATA". Both are exported from another program, that's why they are in separate files, although they can be on separate worhsheets if there is a need. I have to copy cells from "DATA"...
  2. C

    If cells in a column match then combine all values in another column

    I am not sure if there's even a formula for this to work. I attached images to show what my data looks like now and what I would like as the end result. The file I am working on actually has 9800 rows so this would be such a huge relief to have this work. Basically, if part numbers in column A...
  3. J

    Find a value with a list of values

    Is there a function similar to SQL where I can see if a value is within a list of values, such as: ValA in ("abc","def","ghi")
  4. K

    Could enyone please help

    Hello, I'm desperate, i have a lot of recors and can not do this by checking it one by one, because it's a montly assignment. I have an excel Worbook which consists of 2 sheets. Each of them have columns from A to AQ and about 17000 rows. What do i need to do: If value of E2 in Sheet1 is Equal...
  5. E

    Macro for updating a cell on a value match

    Hi, I have used excel for real basic stuffs hence very new to macros and such stuffs.. I ll describe my requirement in brief: I have a 'name' field (person entry) and 'count' field (score) in the below format in Worksheet1: Name Count ----- ------ abc 5 def 10 xyz 10 In Worksheet2, I have...

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