Recent content by alow

I've been mostly absent but logged in an replied to a few posts today, thought I might try and get my activity back up a bit, so here goes:
1. I used to play bass in a local heavy metal band.
2. I went from working construction to computers
3. My university tried to give me the first name "B"...

I'm sure there are ways to do this with formulas, but I think there is a simpler solution. I would copy both of the full lists to a new worksheet, one after the other. Then go to the Data Tab and select Remove Duplicates (assuming you're in at least Excel 2007, if it's an older version, I...

Frank,
I think your problem is with your formula having a static reference for the first part of the array in the COUNTA (The dollar signs). Since you have the reference in the original location as $B$10:B10, when you copied it over, it kept the reference so your new location is counting...

I'm using most things at home.... I have a MacBook for work and a Fedora Laptop for school. I have, however, installed Windows 8.1 on my gaming desktop I built late last year. My main reason for it is that doing a lot of Sys Admin work, I wanted to immerse myself in what is basically Server...

Never a good thing to see a cruncher drop off, but it's certainly an understandable decision. I had to drop off myself for a while, and just (5 minutes ago) finished installing WCG again and starting it up. Be nice if you could get breaks on the electricity bills if you were doing things like...

Without seeing the data, or testing it out, I would assume just a rounding issue. You could put a =round(<yourSUMeq here>,0) and it will round 9.21E-12 to 0. 9.21E-12 is the same as 0.00000000000921 (essentially 0).

Hi Steve!
I just wanted to ask a few questions that may get us pointed in the right direction. What version of Excel are you working with, do you know? In the bottom left hand corner of the screen, you should see a Status like Ready, Edit, Enter, something along those lines. What does it say...

Hi,
I'll see what I can do to help you out, but would you be able to list out the criteria you need, and the numbers you are trying to sum? Are you looking to sum the 10 largest numbers in column C that meet criteria in other columns? Which columns have which criteria, and what do you need to...

The best way to go about something like this is to begin by building and saving a query that shows data grouped the way you would like in a report. Then you can use this query as the basis for the report.
Good luck!

Give the following a try:
=MID(A1,FIND("-",A1)+5,2)&MID(A1,FIND("-",A1)+3,2)&MID(A1,FIND("-",A1)+1,2)
Change A1 to the first cell that has your codes, and then you can copy the formula down. It will look for the position of the hyphen and add from there to get the starting spot for the...

can you provide a small sample of your data? It can have dummy numbers, I just want to see the structure. One of the problems first off that you'll likely run into is that whether or not you have a filter, Excel will usually still calculate hidden cells. If you provide a small sample of how...

What you would do for that is create a list of numbers 1-24, then create a column for sorting using one of the random number formulas and resort the table on that column. It will mix up your 1-24 numbers.