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