s.no

  1. V

    Formula or VB Code in a data sheet

    Hi and Thanks in advance i have post earlier some problem and get the solution but that was in complete and also i have lost that post url. Problem is, i have following sheet <tbody> Col A Col B S.No. Student Work 1 2 2 3 3 6 4 8 5 4 6 2 7 3 8 6 </tbody> In the above...
  2. R

    Sorting Alphanumeric characters

    Hi The below is a set of data which I have where the sname is sorted in a particular sequence. Abcd....z0123456789 So the record are sorted first with alphabet character and then by number. But when I try to sort the same in Excel it doesn't work according to the above order. <tbody>...
  3. N

    Split the total rows for every 250

    Hi, I have an excel file with data in Column A and B. On an average it will be somwhere 3000 line items. I need to find the first 250 line items and insert a row below and Add up the Column B and repeat the same process of splitting 250 till the end of line items. Challenge is that in Column...
  4. K

    VBA alternative for MAXIFS (to use with non Office365 versions)

    Hi, Although I frequent Mr. Excel to figure out resolutions for my VBA issues, this is my first post here coz after racking my head on this repeatedly I have not gotten anywhere :( The data scenario: I have over 15,000 rows of data in a format similar to the sample table below: <tbody> S.No...

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