Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need help with finding a specific formula
Hi Within Excel I want to be able to run the following formula. I want excel
to do the following in laymans terms We have a coloumn of figures. I want excel to look through the coloumn and if any of the figures match I want to add a value on to the original value ! Hope that makes sense and hope someone can help Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need help with finding a specific formula
You could do this with a pivot table.
"Dave Edinburgh" <Dave wrote in message ... Hi Within Excel I want to be able to run the following formula. I want excel to do the following in laymans terms We have a coloumn of figures. I want excel to look through the coloumn and if any of the figures match I want to add a value on to the original value ! Hope that makes sense and hope someone can help Cheers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need help with finding a specific formula
Hi Dave
Do you mean COUNTIF() In Cell B1 enter the number you are looking for, say 5 in C1 =COUNTIF(A:A,B1) will return the number of 5's in column A. Is this what you mean? -- Regards Roger Govier "Dave Edinburgh" <Dave wrote in message ... Hi Within Excel I want to be able to run the following formula. I want excel to do the following in laymans terms We have a coloumn of figures. I want excel to look through the coloumn and if any of the figures match I want to add a value on to the original value ! Hope that makes sense and hope someone can help Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding specific values in a within a file | New Users to Excel | |||
What Excel Formula = finding dup records and removing them? | Excel Worksheet Functions | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Creating a specific formula | New Users to Excel | |||
How can i imput a formula in excel for finding the area of a regu. | Excel Discussion (Misc queries) |