merge down

  1. R

    Merge rows based on row label unique value

    I’m having a list of more than 100,000 data. First column has item number, second column has the notes that are associated with it. One item number might have many notes. Currently the data is like this item note 123 abc 123 cdf 456 adad 789 cfc 789 dfa 789 ada 901 dak 234 kad...
  2. J

    how do i merge down a sum of formulas into one function

    ok i have written down this =LEFT(A1,3)&MID(A1,FIND(" ",A1)+1,3)&MID(A1, FIND(" ",A1,FIND(" ",A1)+1)+1, 2)&RIGHT(A1,2)&TEXT(MONTH(TODAY()),"00")&RIGHT(YEAR(TODAY()),2) i put these formulas together to generate SKU for my store. I wanna turn this into a function named SKU(), for easy access in...

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