Hi all, I have a file contain 10 sheets,every sheet contain list of names,i need to know the frequncy of certian name all over the 10 sheets. Thanks

I need a formula that will do the following: if the sum of j10/h10 is less than 50 then put the answer in red and bold. Thanks in advance to anyone who can...

Hi, I have thefollowing Y1 Y2 Y3 Y4 1000 1000 1000 1000 800 800 800 640 640 512 Total...

Hi All, How can I have a formula to get % variance (+/-) without generating an error? for eg: if A1=100 and B1=150 then I shud get in C1 50% and if...

Hi, I am using the following formula to get number of days passed excluding Fridays in a given Month from fisrt date to the given...

Helo, When I open a revious saved MS Word /Excel file Eroor come as - DATA Error . Please help to recover. Thanks in advance ABDUL

I have thefollowing Y1 Y2 Y3 Y4 1000 1000 1000 1000 ...

I am trying to format the number 12345612345123456 to display as 123456 12345 123456 by entering a custom format code 000000 00000 000000. But the result...

Hi, Is there a way to find how many Day (eg. wednesdays) within a a date range? Like how many Wednesdays (any given Day) falling between June 1, 2009 Till...

"Todd" wrote: I have a column of data that links to another sheet I need a ytd total for. The problem is that the cells contain formulas (on the feeding...

sales data how i can list weekly,monthly yearly etc..etc...

Hi, I have a problem in Excell 2000 for the last 3 -4days. Whenever I open a sheet and make any changes in the sheet it copies and opens a seperate sheet with...

hello R/sir i need detail of Excel Function's pleas Gide me -- Message posted via...

Dear Sir, In Excel there is no "Rows to repeat at Bottom" under page setup tab. can you check and advise. rds,

I HAVE TWO SHEETS.FIRST ONE CONTAINS THE DETAILED DATA AND THE OTHER ONE SUMMARY WITH 'SUMIF' FUNCTION. BUT WITH THE FILTERED 'DETALED DATA' THE SUMMARY...

Why & when we use array formuals in our worksheet? -- Regards,

Hi All, I m using sum if function to sum values with specific criteria...the problem occurs when I want to know that exact precedents of the formula is there...

Hi, I have many cell with values like 01/ab123/09 01/123A/09 1/1A/9 I want to extract the middle value of each cell how could I do This.

Dear Sir, I want to use sumif function inside sumproduct function Pls help me out

I am having a problem with my pivot table. I am trying to count a series of words that reoccur in both the upper and lower case. However, instead of...