In the data tab there is a subtotal option. You will need to add a column for the categories you want to group by. Subtotal by column. Subtotal the values.
I don't have it in front of me or i would be more specific

Idk the middle two.

The last one you need to be more specific. What do you mean by selecting? If you are performing a function, use something like sumif or countif or singer form of an =if function.

Having trouble with IF function, could also be a better formula to use too.

Example of what I want:

If X>325 than 3*.75, if X between 305 and 324 than 3*.65 etc...

Its a formula to assign value to passing yards bonus in FF

Any help/suggestions?

Thanks

=IF(A1>=325,2.25,IF(AND(A1>304,A1<325),1.95,1))

where A1 is the number of passing yards. it returns 1 when passig yards are under 305

.

What function can I use to enter a number on sheet one and pull info from a 3x6 cell referance on sheet 2 if the number is equal?

Probably some combination of match and offset or vlookup but that question is pretty vague.

Not sure if there is an easy way to do this, but I'd like to find a quick way to merge the content of cells in column B when they share a common value in column A.

EX:
A ................ B
100 ...................... 595-5
100 ...................... 596-4
100 ...................... 374-4
200 ......................484-3
200 ......................950-5


So I basically want to be left with:

A ................. B
100...................... 595-5, 596-4, 375-4
200 ...................... 484-3, 950-5

I assume a macro would work, but can't say I'm good enough to create my own.

Just pivot, put everything in the row labels in the order you want it and then structure it in tabular form.

Copy out if desired.

http://datapigtechnologies.com/blog/...-a-pivottable/

Just gonna leave this here. If you ever need to turn tabular data into row data this is so incredibly helpful.

Way more often than I'd like, I get fed data that is in crappy tabular format and while I can fix it using VBA it takes longer than I'd like and I hate QA'ing it. (I'm not that skilled at VBA). This just makes things so much easier.

Sorry, I misread what you had and my above text will just give you what you had before, I'll have to think about that one.

Then copy/paste values, sort on column D.

+1. You just saved me hours and hours of tedious work. It's exactly what I was looking for.

Thank you!

Glad it helped.

I want to take a moving balance and divide it by a static cell reference. Think a balance forward column for a check register. Is there a way to move the cell reference to the bottom-most value in a column? Its not necessarily going to be the highest or lowest value in the column which complicates it for me.

Formulas > Name Manager > New

Give it any name you want, and enter that formula in the 'Refers To' box. Change your column as needed.

You can now use 'myBalance' or whatever you called it in formulas and it will return the last number in the column.

Thank you

How can I conditionally hide rows of a pivot table efficiently?

Currently I am looping through each row and it's cumbersome.

Can everyone stop using grid lines in graphs unless it's actually necessary?

Add a filter?

The problem is, the data consists of unique order ids. There are 20k+ of them.
Filter's cant be set to formulas (like conditional formatting), which is rather annoying.

You can filter greater than / less than. Is it more complicated than that?

Oh, can you add a column with a formula and then filter on that? Have the formula return "x" if your conditions are met, then filter those out.

I did add a column now, but was wondering if there was an easier way.

I have 2 worksheets. First one is lookup second for reference.

I want to be able to enter a number on sheet one and have that reference/search all my tables on page 2, bringing the table with matching number over to page 1. So if I enter 100, the table with Issue qty of 100 will be moved over, If I enter 200 the corresponding table of 200 is moved instead. Do I need to turn anything into a pivot table? Do I use VLookup/HLookup formulas? What is the best option?

(sheet1)

Issue qty: xx
(Matching table/Cells will be transposed/brought over from sheet 2 to here)

----------------------------
(sheet 2)

Issue qty: 100
A 1 7
B 2 5
C 3 9


Issue qty: 200
A 1 7
B 2 5
C 3 9

How does one count unique occurrences in a column and get the number. Example would be counting how many individual unique rfq id's are in the column. 2 3 4 4 5 I would want it to tell me the answer is 4. I tried count functions and the answers from Google were difficult to understand.

Sent from my SAMSUNG-SGH-I747 using 2+2 Forums