Search results

Thanks! I went with your first suggestion. I did that and when I go back to hi-light all the columns from B to N, there are a lot of CF. I'm amazed Excel can't simplified such a tiny conditioning.

Hi, I have several columns of data. Say column A to column N. Now each column will have 10 data (figures) from A1 to N10 where each column represents a month's worth of 10 important data. I was trying to use conditional formatting to hi-light just two colors but I can't get CF to work out...

Thanks, Luke M. my concern of list box is that the user move the box around and it'll look ugly and unprofessional. I'll give it a try later today or tomorrow. I'm completely swamped today. Many thanks!!

Holy cow! that's awesome! yes, the yellow dots do disappear from time to time. Amazing!

if you are using 2007 or after, you can do so by customizing your quick access toolbar. the print button will show up on top of the Excel window. No macro, no formula to worry.

=year(date) =month(date) =date(year, month,day)

Hi, I have a worksheet where users can choose the language type, depending on the users' native language and the workbook covers 8 different languages (default to English). When a user opens up the file he'll be prompted to click a pull down menu to choose, say, german. And the entire excel...

Hi all, I'm about to work on a new project on sales commission. What are the most common functions and peculiar functions that you have come across for commission calculation? I would like to gather some ideas so that when the project starts it'd be easier to do. Thank you all!

lol Luke beat me by a minute again! Note to self: cut the jabbers. ;)

you need to change the number "3" in your original formula into a if formula. If(d2="old",3,5) or something like this.

So manster, it's like this. let's set up the worksheet A1: 100.1 (or any number you want) A2: 50 (or another whole number of your choice) A3: blank C3: A1-A2*3 (this is also the cell displaying the result. In solver, you specify: Set Target Cell: $C$3 Equal to: Min By Changing cells...

please kindly upload the file to have a look? Thanks.

Hi Bill, May be you need to elberate a bit more. may be upload a file of your intention? Thanks.

Thx, SirJB7. would be hard to understand this. but thank god I don't have to use it on a daily basis. It is giving me headache to comprehend its rationale.

Hi SirJB7 I checked out the file and I guess the user is asking for "only" the days as if they are in complete calendar days between the dates as if they were of the same month and same year. Then i have a question with your answr on 30 (line 426) if start date is 31st and end date has a...

@SirJB7 First of all, I don't understand why the answer has to be 30. I read the FIRST posting and it didn't specific why the special need for datedif. It only said he's trying to find out "number of days" between two dates. Second, when I said format of the cell to general is because...

I doubt that's the only part where it is wrong. is this part of a bigger formula?

@SirJB7 I read the original question once more and Ifrazier is asking the difference in "months", not "days". So I don't understand what's wrong with my formula. The only thing not clear in his original posting is whether the stated 12/31/2012 is the start or end date. I do not understand...

@Nitika.Kaul reading your original posting, why not just use cell2 minus cell1 and change the format of the calculated cell to general to show the number? Why use Datedif? You don't need make it a complicated matter.

When someone creates a workbook and put it up for others to read, the creator may know or have some idea whom the readers/followup users are. See if you can get an idea there. Under "details" there should be a "computer" name. give your IT dept the name of the computer name, say ABCD-1234...

http://chandoo.org/wp/2011/05/16/lost-excel-functions/ DATEDIF(start date, end date, "M")

You may get a better answer by going directly to the department and ask for the person(s) who did that.

I like your first suggestion.

hi SirJB7, How does the worksheet update itself when say, AF2 is changed to a positive number? Given the large number of rows of vendors?

Well, I can't afford too much time on this so i'll just go the simple helper lines method. I did it in a separate worksheet. each answer will need 2 support lines. so a total of 4 helper line per vendor. For your B2 the formula is: INDEX(1:1,1,MATCH(A2,4:4,0)) where: E3 =...