len formula

  1. E

    Excel 2010-What method to use to identify info missing or in error?

    Hello Excel Gurus! Thanks to anyone who can point me in the right direction. I have been tasked to create a "smart" data collection form in excel 2010 where a user inputs collected info from a call. The form is divided into 5 main sections with as few as 6 and as many as 26 manually input...
  2. A

    Signed hex numbers

    I teach computer forensics classes and we have the need for a formula that will determine if any length hex number (typically 2,3, or 4 bytes) is negative and, if so, convert that number to its negative decimal equivalent. I have been able to do that with the following formula (cell E5 contains...
  3. J

    SUMIF or COUNTIF using LEN for a range as a criteria

    Hi guys, I'm trying to figure something out. A:A has values with 12 or 13 characters, I need to count the number of times each value returns. I tried =COUNTIF(A2:A11;LEN(A2:A11)=12), but this results in 0 instead of 6. Any help? I couldn't find any answers that worked for me.
  4. J

    Trying to sum data that fits certain criteria

    I can't seem to figure this out. I'm trying to sum data that fits w/in two dates I've specified. Normally, this would be a simple sumif formula. But the data I'm actually summing has text string and so Excel doesn't see the numerical values to be able to add them. Here's what my data table...

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