PivotwDescrip
|
|
|
|
|
|
|
QUESTION
|
|
|
|
|
|
Hi, i need help i have a pivot table where i want the product code, product description and than cost and quantity. but for product description it doesnt show the text it goes to count of product description. how do i get the text.
Veena Sultan
|
|
|
|
|
|
Insert a new sheet... copy and paste the information on this template and throw a QUESTION.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
|
|
|
|
|
|
|
|
|
|
8
|
|
|
|
1
|
|
8
|
|
|
|
2
|
|
|
|
|
|
3
|
|
|
|
|
|
4
|
|
|
|
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
6
|
|
|
|
|
|
7
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Answer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feedback
|
|
|
|
|
|
Type your feedback here… was it usefull? Does it work? You have a different Excel version??
|
|
|
|
|
GreenRedNumber
|
|
|
|
|
|
QUESTION
|
|
|
|
|
How do I make positive values appear green and negative values appear red automatically? Say my numbers are -1, 2, 3, 10, -13, -4
|
|
|
|
|
|
Insert a new sheet... copy and paste the information on this template and throw a QUESTION.
|
|
|
|
|
try to stick to this form... Please describe your question on the correct section and put any info that can help.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1.00
|
|
|
|
|
2.00
|
|
|
|
|
3.00
|
|
|
|
|
10.00
|
|
|
|
|
13.00
|
|
|
|
|
4.00
|
|
|
|
|
5.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Answer
|
|
|
|
|
It's called "Formatting Numbers"... Select ALL your cells or range and apply the green color you'd like to use... then go to menu "Format" and submenu "Cells" then on the pop-up menu go to tab "Number" go to category "Number" and select the choice in red, either with parenthesis or not.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feedback
|
|
|
|
|
Type your feedback here… was it usefull? Does it work? You have a different Excel version??
|
|
|
|
Priceby1.06
|
|
|
|
|
|
QUESTION
|
|
|
|
|
Hello all, I'm preparing a new price list and I need to multiply all prices with 1.06.
I have hundred of prices and what to know if there any formula which will multiply all selected cells with 1,06
Thanks for your helps in advance!
Fatih
|
|
|
|
|
|
Insert a new sheet... copy and paste the information on this template and throw a QUESTION.
|
|
|
|
|
try to stick to this form... Please describe your question on the correct section and put any info that can help.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Product
|
Cost
|
List Price
|
|
|
A
|
34
|
36.04
|
|
|
B
|
25
|
26.5
|
|
|
C
|
12
|
12.72
|
|
|
D
|
5
|
5.3
|
|
|
E
|
43
|
45.58
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Answer
|
|
|
|
|
Above is just an example, there are several ways to do what you need to do. Including, referencing a cell with the
increase value, using names, using a column for the increase value...etc..etc. (=C3*1.06)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feedback
|
|
|
|
|
Worked OK
|
|
|
|
Template
|
|
|
QUESTION
|
|
|
|
|
|
|
|
|
|
|
|
Insert a new sheet... copy and paste the information on this template and throw a QUESTION.
|
|
try to stick to this form... Please describe your question on the correct section and put any info that can help.
|
|
|
|
|
|
Examples
|
|
|
|
white real estate
|
|
start date
|
|
end date
|
|
wages
|
|
tax
|
|
weekly savings
|
|
weekly committements
|
|
out goings
|
|
amount saved
|
|
|
|
|
|
|
|
Answer
|
|
|
|
|
|
|
|
|
|
|
|
Feedback
|
|
Type your feedback here… was it usefull? Does it work? You have a different Excel version??
|
History_
|
|
|
|
|
|
IssueID
|
Question
|
Answer
|
Feedback
|
|
1
|
Hello all, I'm preparing a new price list and I need to multiply all prices with 1.06.
I have hundred of prices and what to know if there any formula which will multiply all selected cells with 1,06
Thanks for your helps in advance!
Fatih
|
Above is just an example, there are several ways to do what you need to do. Including, referencing a cell with the
increase value, using names, using a column for the increase value...etc..etc. (=C3*1.06)
|
Worked ok.
Thanks.
|
|
2
|
How do I make positive values appear green and negative values appear red automatically? Say my numbers are -1, 2, 3, 10, -13, -4
|
It's called "Formatting Numbers"... Select ALL your cells or range and apply the green color you'd like to use... then go to menu "Format" and submenu "Cells" then on the pop-up menu go to tab "Number" go to category "Number" and select the choice in red, either with parenthesis or not.
|
|
|