Search results

Hi, I have a 16-mb excel 2007 file. I takes a lot of time to load. Can I make it load fast?

Thanks Luke M, but the formula does not give the required results.

Hi, Column A2:A10 have names column B2:B10 have numbers but some cells are blanks in A22:A32 I want to list down all the names from A2:A10 that have blank cells in front of them in B2:B10 What formula can I use here? I want the results with no blank cells between them. Any help is highly...

Hi, In A2, B2, C2 D2 I have data: numbers or letters A3:D3 are empty what I want to do is the following: When I put any data in A3, the contents of A2 will be hidden When I put any data in B3, the contents of B2 will be hidden, etc. How can I do this?

hi, how to change an excel workbook to a .exe file with the ability of changing data?

How can I repeat printing rows which are at the bottom of the page?

Hi, How do we lock cells so that they cannot be edited, and at the same time leave some cells open for editting?

If I have a list in Sheet2, can I make the CF cells which are red to come at the end of the list?

Thanks Luke M. A genuine answer!

This is a difficult task that I could not possibly solve. In Sheet1 I have the following: B2 has a name John B3 has a name Peter C2 has a number 5 C3 has a number 3 In Sheet 2 I have the following: D12 has a name John D18 has a name peter What I want to do is the following: I want to...

The formula works very well luke, but the longer one has many advantages: it ignores blanks, it puts items in alphabetical order, and it does not show errors

Thanks, but the formula returns 18 for all cases

Hi all, I have the following question for which I need help: In Column A2:A10 I have a list of items with some empty cells. In column B2:B10 I have another list of items with some empty cells. In column C2:C10, the same. What I want to do is the following: In column D2:D15 I want to put 6...

I need the calculation to be automatic because the shortened list is a base for other lists.

I have my original list in B19:B45 I have my shortened list in C80:C85 I use this array in C80 =INDEX(List6; MATCH(MIN(IF(ISBLANK(List6)+COUNTIF(B1:$B$1; List6); ""; IF(ISNUMBER(List6); COUNTIF(List6; "<"&List6); COUNTIF(List6; "<"&List6)+SUM(IF(ISNUMBER(List6); 1; 0))+1)))...

Welcome back Hui Welcome back Luke M We missed your brilliant ideas the last month.

Thanks Hui, I don't want to use filters. I am looking for a formula that does this automatically.

Hi all, In column A there is a list of items: numbers or names, but some are duplicated; eg a a a b d c c a d d I want to make a new list in column B with no duplication a b c d What formula do I use in B? Thanx in advance

This formuls worked well, thanks to you GCExcel. Now, vice-versa: Numbers are in column B19:B49 Names are in C19:C49 short list of NUMBERS are in C80:C85 results are in D,E,F80:85 results should show all the names that correspond a certain number. Any ideas?

How can this formula be amended? =IFERROR(INDEX($A$2:$A$8,LARGE(IF($B$2:$B$8=$C2,ROW($A$2:$A$8),0),COLUMN()-3)-1),"") When the following changes take place: Numbers are in column B19:B49 Names are in C19:C49 short list of names are in C60:C70 results are in D,E,F60:70 Please try it and...

Just another query: What if Column A contains empty cells?

Thanks a lot. This is what I'm looking for.

Brilliant! Thanx dear

Thanks, Can I do this with a formula instead of a macro?

Thanks Hui, I want this to be automatically done, because it is a step in a process.