Functions

Duplicates formula
Result Example Result in col B A B 100 100 100 3 200 300 300 2 Hi I'd like to find the number duplicates in Column A, and place a result in column B as shown on above in Col B. How do you create formulas? Thanks Soth ... 12 Apr 2010 21:28

Ignore Hidden Rows and Count of distinct values
Hi, I need to display the Count of distinct values and also ignore hidden rows in the count. Please help me to fix this issue. ... 12 Apr 2010 21:28

formating
How would I format several cells to change color is one particular cell equals A? ... 12 Apr 2010 09:13

If function with calculation
Hi All, I need to get a result from the following: IF B20 = 0,0 IF B20<35, 35 IF B20> 35=B20 Basically in layman terms if B20 has a value above 0 the minimum showing is 35 if it is higher than 35 then it remains the same, 0 must remain 0. Any help would be great ... 12 Apr 2010 09:13

Merge Cells
I Just want to know how to merge via code two cells: This doesn't work: oSheet.Range['A34:A35'].merge:=true; ... 12 Apr 2010 07:01

Consolidate excel 2007
I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, Sout... 12 Apr 2010 09:13

Basic Question on autocomplete function
Hi everyone, my first time on the forum and my first thread. I apologize if this is already located on the forum here. I tried searching, but came up with many unrelated threads so I thought I'd give this a shot. I am trying to auto complete a link to another worksheet by corner dragging a formula over a ROW in one... 12 Apr 2010 10:19

Counting frequency in unsorted data
hi...I'm looking for a function that will count frequency using multiple variables in an unsorted data set using two variables. I can get the information that I need by sorting the data and then using Data->Autofilter and using the countif function ti isolate the variables individual. However, this is problema... 12 Apr 2010 01:36

how to key in a1 information on e1 wil appear at b1
... 11 Apr 2010 23:26

excel formula
Does anyone know how to create a cell that will calculate whether the number in the orginal cell is above or below 40. If above 40 it will calculate at $69.00 for anything over if below it will calculate at $46.00. Thanks in advance ... 12 Apr 2010 22:34