cust1

Hi I am trying to update values in an inventory sheet but if value has no change then i cannot create a formula to show the previous value. Any help would be appreciated. Hope this makes sense. thanks MC cust1 has starting value of 100 cust2 has starting value of 200 Thanks <tbody> date...

Trying to figure out the best way to turn my rows into columns, while maintaining the values and headers. Looks like a reverse crosstab query or something. I'm an amateur btw... I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months...

Hello All, I have a table of a list of sales to customers and I am trying to create a formulae that will give me the total value of items sold to a customer. Table <tbody> Customer Record Type Item Qty Price Cust1 SI Item1 2 1 Cust1 SC Item1 1 1 Cust2 SI Item2 3 2 Cust2 SI Item1 5 1...

Hello ! I have a following formula here. I am trying to keep track of the latest transaction made. This is an Array Formula entered with Control+Shift+Enter. =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Cu",$A$1:$A$4))) =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Dp",$A$1:$A$4))) <tbody> A B C 1...