advance criteria

  1. S

    SUM rows based on multiple criteria and insert below

    So what i need to do is sum the values in the Units and amount columns if : - the person is the same - "x" starting number of characters is same in the desc column (ex. one__ or three____) - the Cur being "U" Then i need to insert a new BOLDED row underneath each change in colour in the rows...
  2. A

    Need Help [Raw Data to Join Text with comma separated List]

    Hi, I've been thinking to solve this problem for a while but to no avail So I got bunch of raw data with delivery guys who would do shipment in a month like this <tbody> MON-1 TUES-1 WED-1 THURS-1 FRI-1 SAT-1 MON-2 TUES-2 WED-2 THURS-2 Andrew 12,00 12,00 12,00 Ashely 12,00 11,00...
  3. Z

    i need to filter data that contain what the user's input, not only begins with user's input or exact

    hi i was wondering if anyone can edit my code. the code here only filter if the data only if it begins with what the user input Example: Data: dean winchester sam winchester john winchester mary winchester Now - input: winchester result: no data want: input: winchester result: dean...

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