Search results

do you have a picture or file to show us?

go to conditional formatting; format only cells that contains the word "compass". set the color to pink. Hit the enter key.

using name you can use vlookup for instance vlookup(employee name,database,selected date from your pulldown menu minus 40907, false) i'm assuming all the individual worksheets will have the first column as name and data starting on the 2nd column.

can you give an example to "count certain cells which contain a specific word as well as a specific color"? Mike86 already give you the answer to the count. If you want color based on "Jan", a different color base on "Feb", etc. you can use conditional formatting.

you can read this post and the subsequent link http://chandoo.org/forums/topic/countifsumif-with-linked-workbook http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/

I just can't wrap my head around the computation rationale that the failing rate is 11/60 and not 11/71...

=if(or(x>==40909,x<=40999),"Quarter1",if(or(x>=41000,x<=41090),"Quarter2",if(or(x>=41091,x< =41182),"Quarter3",if(or(x >=41183,x<=41274),"Quarter 4",""))))) X is the input date if the result is blank that means you have entered a date that's outside of the...

you can still use the indirect function. instead of choosing the sheet you can have the pulldown menu to be A, B, C, ... so you can compare all the columns D, for instance. INDIRECT(Sheetname&"!"&pulldown cell & 1, TRUE) and replace 1 with 2, 3, 4, etc as you expand the list down.

do you mean you want to create a pull down menu to pull the data from Sheets 1 to 3 and on a certain column? say you have 10 data from A1 to A10 on sheets 1 to 3. on the summary page you want to create a pulldown menu pointing to Sheet1, Sheet2 and Sheet 3. Then you can use indirect (...

I agree with oldchippy. This is what i've seen many times. You may want to put a comment to the reader that the difference is due to trailing numbers. Or you can do something a bit different. If you can get approval (as in my case) I rounded all decimal to 1 place. So the end result...

On behalf of Chandoo, welcome to Chandoo! ;) A1 Text "Overall Amount" B1 Enter the amount such as $150000 C3: "Price", D3: "Breakdown", E3: "Total Fees" A4: "Level 1", A5: "Level 2", A6: "Level 3", A7 "Level 4" B4: 10000, B5: 30000, B6: 50000, B7: 100000 C4: $1.00, C5: $0.80, C6...

Thanks, Prasaddn.

a date is a number. for instance, 1/1/2011 is 40544. So all dates you are entering would be bigger than 365, unless you are entering dates from the year 1900.

What is a command button? I'm not familiar with that?!

Thanks for the confirmation!

Just want to post this to make sure I was right... There is no way to have Excel formula calculating certain answer just to have the formula removed at the end, without using macros, right?

Thanks. I know transpose. I thought there was a more direct way to fix it. I'll probably use a helper worksheet hidden in the background to do the placement of data and calculation. Then link the answer back to the main page. Why do people want to place their data in such an awkward way?

Hi, I was presented with a question with 2 database tables (which I think is poorly constructed). Table 1 Rows 2 to 10 have some data reading horizontally. Cells A2:A10 are the headers. data going from B2 to U10 Table 2 Row 12: Headers A12 to F12 Data: A13 to F32 In the empty area of...

Also, have you check to see if there is hidden worksheets?

It works! thanks SirJB7. I enhanced the area with conditional formatting with =AND($B6=$B$33,D$4=$D$27) and two simple one on the header row and column.

you may want to delimit the cell converting them from text to columns.

=LEFT(C:C,FIND("(",C:C,1)-1)*1 copy down

oh i see what you want, please ignore my last post.

i'm sorry it is a bad sample data table. you have both 30/6/2011 True 30/6/2011 False 30/6/2011 True Which one is true and which one is false?? also, you have 15/7/2011 as true but 07/07/2011 as false. I don't understand your criteria fitting into between 1/6/2011 and 30/6/2011 once...

Hi OleMiss2010, I can't visualize and connect all the talking points. Could you please upload a file so I can see what you are asking (the driving cells and dependent cells)? Thanks.