Search results

Here is a question: $AMT PAYEE1 PAYEE2 PAYEE3 PAYEE4 438 A B 409 C A B D 171 B A D 248 C 117 B A C...

https://docs.google.com/open?id=0B1Yt3Yl95LuPcE5EM2tGcHQ5VEU Hi all, I'm trying to write a formula to find out the 2nd and last occurence of accounts. See link. I can get the 2nd occurance but how do I identify the last occurance without using filter and manually work them out? My...

I have searched around but I can't find a short cut in formula. A1 is an input cell. You can enter any whole number from 1 to say 1000. in column B501:B1500 are the data. I'd like to sum the first X (from A1) number of rows between B501:B1500 Example if B501=20, B502=35, B503=12...

https://docs.google.com/open?id=0B1Yt3Yl95LuPUnY5R1VMNWQ1eDg OK. it is obviously i'm hopeless in sports and here is the excuse not to hit the gym any time soon (or any time at all!). But I'm curious how come I only made 18 errors (i know I only made one) but took 112 years to finish the...

I have 2 formulae one using sumif and the other one using sumproduct. Both get the same correct answer but they look a bit too long to me and i can't find a shorter way to express. basically i need to find out the sales volumn by names and I have names on columns W, AA and AC. There are...

Hi all, I have a formula like this: ="Total Count: "&COUNTA(A2:A2000) and the anser is "Total Count: 1234" which is correct. But how do I make it more pleasing to the eyes to add the "," between 1 and 2 so that it reads "Total Count: 1,234" instead? Please kindly advise. Thank you very much.

Couldn't go to main page. is it still down?

Hi I have 3 columns of raw data (a few thousand lines) column A: Customer Numbers (one number to one specific customer) column B: Customer Names column C: Sales figures A customer in any given month can have multiple differetn sales figures (multiple deals). So in column A customer 1234...

My boss popped a question and ask me for the dates of Friday on the 33rd week and the 49th week in 2012. I browse around the blog but all subjects were on dates converting into something else. You know, we start with a date then fidn out the week number or weekday using weeknum() and...

Hi, I have a worksheet with an input sheet and an output sheet. On the output worksheet there is a list box displaying workers' names (e.g 100 names). By clicking on a different name it will display the info of that worker in a report format. Currently, when I hi-light all the names in...

I have a list of employee names in column A2 and down a few hundred rows in Sheet1. In Sheet2 I have a pulldown menu referencing the names in Sheet1. Depending on the name chosen, Sheet2 H18 will compute different performance number for different employees. Question: Is there a solution to...

Hi Chandoo/Hui, Is it possible to write an article on MS Excel 2010 Solver. Solver is so different from what I'm used to and all the new feature are not easy to understand, such as GRG non linear, simple LP, evoluntionary, options, Reports: Answer, sensitivity, limits, outline reports (I...

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...

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...

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...

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...

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...

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!

Hi, I was reading http://chandoo.org/forums/topic/return-last-5-entries-of-a-dynamic-list-ignoring-blank-cells and wonder what if I want to return all the numbers (or text), instead of just the last 5 numbers?

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?

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...

I have a set of data from A1:B4 on column A down: a, b, c, d on column B down: 2, 51, 3, 7 I tried AVERAGEIFS($B$1:$B$4,$A$1:$A$4,"a",$A$1:$A$4,"c",$A$1:$A$4,"d") AVERAGEIFS($B$1:$B$4,$A$1:$A$4,A1,$A$1:$A$4,A3,$A$1:$A$4,A4) but they are all giving me the answer #DIV/0! I'm using MS07...

I was asked to protect certain cells in a worksheet, so that the users cannot manipulate the formula or overwrite them. That was easy. But then I was also asked to make the worksheet flexible enough to allow the users to hide rows and columns. I'm using MS 2007 and I have tried with no...

My colleague sent me a pivot table with 1. multiple columns of monthly data (deparment, Names, Cost center names, cost center numbers, a few columns of spending by months) and a total columns 2. multiple rows of data with a subtotal (spending by individual within a department, then a grand...