# sort and formula

1. ### Excel - sort data (smallest to largest) with 2 or more criteria in formula?

I am trying to find result of sort data in table with specific criteria for example : The picture of excel-table that i trying to figure it out yellow is ALL-JOB fill by user RED is Unfinish JOB sort by "START DATE" Green is Completed JOB sort by "END DATE" and "JOB ID" i need to sorting data...
2. ### VBA Sort Data and Treat N/A as Zero

Hi Team, Can you possibly help me simply the recorded codes below: The range must be until the last non-blank sheet and if N/A was found on the cell it will be treated as zero when sorting in descending form. ============================== Sub Macro1() ' ' Macro1 Macro ' '...
3. ### Counting text data until change in state

Trying to count the number of BOBs or WOWs in the BOB\WOW column before there is a switch from one to the other. It doesn't matter if the first cell is a BOB or a WOW I just need a numerical count on how many there are in a row before there is a switch. In each of the BOB\WOW columns I will do...
4. ### Sorting data in all connected sheets without loosing information

Hey, I need help sorting out student attendance data. <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style> For example, this is January Sheet. Data is sorted by Column B (#ID)...
5. ### Failure of MS Excel to sort properly in value in one row are linked to the values in other by a formula

Please see this link: https://drive.google.com/file/d/0B0F5ZCsTvPP2Tm9fRWVWT1pZZzg/view?usp=sharing Open the sheet - Capex. See the value of quantity (highlighted in yellow) for items Laptops and Mobiles by sorting on Item and Category alternatively. You will see, it shows 10,10 once and 10, 100...

### 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.

### Which adblocker are you using?

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

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