I have a large spreadsheet that includes the following detail. Column F has numerical values of either 1, 2, or 3 ranging from F2:F276. Column Q has varying...

Hi, I'd like to have more than the two criteria to filter some data, to filter out all those rows that contain Mr, Mrs, Miss, Dr, The, etc. etc. Is there a way...

Can VLOOKUP be used to search columns in multiple sheets in a workbook?

I've noticed that there are 53 Sundays in this year 2006. My question: Is there a way for Excel to determine how many Sundays or any other day of the week that...

Hi, Is there any way i can format a cell with more than 3 conditions? Thanks in advance -- penri0_0

I am entering info given to me here on the Forum, I am getting an error and this line is highlighted. For Each myCell In myRange.Cells I don't know VBA or...

I'm having problems getting David McRitchie's pushdown macro to work correctly. I've worked through the code and changed some "" to be "", and vice-versa,...

Hi guys, one of my friends developed a Utility for importing Yahoo India stock quotes into Excel. But it shows the data like...

Ok Gang, This is going to be a Hard one for you Smart people. I need a Super powerful Macro so when i click on the macro it automatically saves the chosen...

I noticed that if I have multiple instances of Excel, the copy and paste functions behave differently. Specifically, if I have two instances running and I try...

The following formula counts the number of non blank cels in row e, and totals the number of cels that are non blank on the summary page: {=sumif((dress! a:a =...

I have a column containing numbers 1-40. I made sure the format of these cells is "Number" then I sorted my spreadsheet in ascending order. The strange thing...

I am able to copy a custom set of colours from an existing worksheet to a new one. However I would prefer to change the default colours in all...

Dear Gurus . ... I have a worksheet with 5 columns and 400 rows. All contents are sentences. I use Vlookup but it only can show result that matches the...

To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation. Thanks will A

Hi, everyone... Building formulas is not yet a strong area of mine. I'll keep it concise. The scenario: Given: Columns A, B and D, respectively: Vendor,...

Does anyone know how I can paste the find all into a new column in the same corasponding row number? I did a copy from the "Findfind all" list by...

I currently have my Vlookup stmnt as this: =IF(E2="","",VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE)) 'Code Decrip' is the name of the worksheet I need to add...

Hi- hope someone can help with this pretty specific problem- I have just upgraded to a new version of excel (2003), and have an issue with when I am opening...

Here's the deal... Open Excel New worksheet Enter data Sum data No matter whether I add numbers from column to column or row to row, my totals are always...