Search results

Dear all, All ideas are great, however I think that my problem is much more simpler than this: Column D has the formula of =sum(A:C) This returns the value of 0 if the cells A:C are empty. I need to have the average at the end of col. D, but the program counts all the cells that have 0...

Thanks dear, the formulas did not do the required task. They returned the numbers that are less than 5 to 0

ok sir, I'll try this

Hui, The names are not in the same row.

Hi, I have columns A to E Names appear in these columns some names appear in all columns some only appear in 3 or 2 columns How to find those names which appear in all columns and put them in F How to find the names which appear in 4 columns and put them in G etc. ?

Hi, I have this formula: =IF(AND(C1>=0;C1<5);A1;"") It works fine for me but there is a minor setback: It calculates the empty cells as zeros. How can I adjust it so that it won't calculate the empty cells as zeros? Only when I put a zero (0) in a cell, it should be calculated.

Thank you for your help, sir

Thanka asa, Good idea; however I need this to be automatically done so I get the final result without highlighting the original list

Hello every one: I have a list of items in column A But A2, A4, A5, A9 are empty All the cells from A1 to A12 are full except the cells I mentioned above. How can I make excel 2007 group the items without blanks among them noticing that these blanks may change every time, I mean that next...

Hello every body: Have yo got any idea of hoe to make excel 2007 automatically eliminate empty rows from a list of rows?

Thanks luke, I have uploaded a sample file. please download it and see what can be done. http://www.2shared.com/file/S0rzCwWM/conditions.html

Luke M, Will you please explain me how the array formula works and what it does? because I did not get the desired results using it. Thanks dear friend.

Thanx Srinidhi, I'll start it over: I have columns A, B, C, D and E All pupils' names are in A B and C contain marks: Column B for the passing pupils and C are for the failing pupils I need Excel 2007 to group all the passing pupils in D and all he failing pupils in E. I want the names in...

Thanks, Luke

To put it more clearly: I have list of pupils in A, some are passing, and their marks are in (B), and some are failing and their grades are in (c). I want to list the passing pupils in (d) with no gaps between them. I want to list the failing pupils in (e) with no gaps between them...

Thanks very much Luke.

Hello, Can you help me with this? I have columns A, B, c, D, E, F there are numbers in A, B, C, D When the sum of A:D is between 0 and 20 I want it to appear in column E When the sum of A:D is larger than 20, I want it to appear in F Any ideas please?

Hello allk I need your help: I have columns A, B, C, D, E There are products in Col. A, there are prices in either B or C I want all the items whose prices are in B to be listed in D I want all the items whose prices are in C to be listed in E Any ideas?

Hi, When I put the cursor on the small arrow, the image flickers. How do I show a still image?

Thanks to you Hui, I learned a lot.

Really sorry Hui, All I meant is that I am totally confident in your help and detailed answers. Thanks a lot for your help. I made the amendments, saved the changes but it did not work. I am using Excel 2007. Is that the reason?

Waiting still

Dear Hui, I have made a spread sheet following all the instructions in the video, I hope, but it gave me the message ( Can't open file ). You can find my file in http://www.mediafire.com/?tk8n5vjvkbaejn6 Could you please have a look at it to see what the problem is? Thanks a lot.

Thanks Hui, You are great.

Dear Chandoo, I saw your Video Tutorial on Interactive Dashboard using Hyperlinks. It is very nice to be able to tell excel to behave just as we want. My question is that How can I link a photo capture taken by the camera tool in excel of some cells instead of the chart in your workbook...