Search results

Hi all, I have created a list box (form control) in excel with a cell link to C3. As I click on the different employee name on the list box and C3 (the counter) would change from 1 to 500 (I only have actual data from 1 to 250, though. I just want to make sure I have enough space for future...

Thanks, Luke!!

I was reading this question: http://chandoo.org/forums/topic/average-best-95-of-list and I wonder what if I just want the top 5% percentile instead of the lower 95 percentile data? How should I do it? I personally have never used this function but i think I may be able to apply this to some...

suppose you have a column A with a title. So on a separate column do this =mod(row(),6) filter everything other than 1 and use go special and delete all visible rows in column A and B.

I need some clarification: you said "IF the staff committed to 40 hours....". Are you hinting that there will be staff committing to less than 40 hours? Like a part time staff? 20 hours, 30 hours, etc? How would these non full-time staff affect your tenure calculation?

Hi Kay, I don't understand 100% what you want when you say correlation between B5 and B6. B5 is a blank cell and B6 is a text cell "INTAKE". Could you please kindly clarify exactly what I am reading on your file? Thank you very much. Also, from a practical view point. Fee/study point...

Try Columns("E:E").Select Range(Selection, Selection.End(xlToRight)).Select Selection.EntireColumn.Hidden = True

Can't you just change the format of the cell to show just the date??

just one more note. I just found out that i can't have Sheets("Sheet1").Select in the vb script when the worksheet is set to very hidden. So I deleted that line and only one line left. And it still work!! Yay!

Hi Luke, You ARE AWESOME! first i got an error message. then i realized i have sheet2, not sheet1. I changed sheet 2 to sheet1. Here is the full script I have and it works beautifully. Sheets("Sheet1").Select Worksheets("Sheet1").Range("P2").Value = False Sheet1 is password...

I guess you need to start with a linked cell for the check box. set condition where if there is one check in one tab the other two box would be "unchecked". so linked-cell#2 formula =if(linkedcell-checkbox1=true,false,true) note that now the driver is click cell#1. You don't want to click...

Hi Luke, The macros didn't work. I tried setting Sheet1 to "visible", "hidden" and "very hidden". .Range("P2").Value = False doesn't seems to work??

Thanks Luke. Let me test it out. The check box is like a Y/N on ordering some products, it is not quantity driven. So if you want it, click on the box and a price would show up and add to the total price. Given the long order list, some quantity driven, some are not. So if user #1 click...

Hi all, I have created a user form where users can click on a check box (made from Form Control). If the check box is checked, a figure will appear in a different cell. So it is either $0 (unchecked) or $100 (checked). I have this check box linked to a different worksheet Sheet1, cell P2...

hi Narayank991. Excel didn't show up any circular notice on the screen (lower left) or any pop up window. /shrug

u can use averageif function = averageif(column1,criteria"dog",column2)

Thanks Narayank991. I ended up moving the formula and consolidated it with other formula under one worksheet. Then delete the original ones. So far I don't see anything out of place. So I guess it is fine. There are just way too many background formula running behind so many worksheets...

I'm facing a workbook with 50+ worksheets with a ton of links across all the worksheets. So when I want to find out what one cell have affect other cells on the same worksheet and other worksheets I used "Trace Dependents". The question I have is that I see a picture of a tiny worksheet thing...

There are many ways to do this. =sumif(), filter+subtotal(9,list), pivot table, etc.

Hi dan_I, sorry I was out for quite awhile. It was a sales quote form in Excel format. The sales quote form would be in English(U.S.), German, Australian, European Spanish(not S. American spanish, i didn't know there is a difference), Norwegian, Italian, Brazilian portugese, Finnish, Swedish...

Here is my comming of using powerpoint to a group of audience (regardless of size, 2-2000+). PowerPoint is not ideal to present complicated, detailed tables/charts. All charts and tables should be concise and "not busy" to the eyes. I found that any charts with more than 4-5 lines and...

thumbs up oldchippy. I knew i should use mid() but too lazy cos I hardly have the chance to use it in every day life.

if you want to find only the difference in amount, then just sum the total. In real life it's not that simple in accounting. you could have entries like +500 (A) but -150 (A), -25.5(A), -82.45(A), -242.05(A) to cancel out. but you may have an identical entry of -25.5(B) somewhere else. if...

if vendor ID is separated with only one space " ". that'd be easy. suppose the name is in J1, LEFT(RIGHT(J1,LEN(J1)-FIND(" ",J1,1)),FIND(" ",RIGHT(J1,LEN(J1)-FIND(" ",J1,1)),1)-1)

Hi SirJB7 the other concern not to use Active X List box is because the worksheet will end up printing on a PDF format and cell pull down would look "cleaner" to the reader without seeing the border of the pulldown button. The worksheet cannot be protected because the users want to make all...