Search results

I have numeric values in columns A & B in about 200 rows. Column C2 has the product of col A&B using a simple formula: = A2*B2 Some cells in col A or col B or both are blank in which case col C will display a numeric zero. But i prefer col C to display a 'blank' instead. So i use the formula...

Excellent! Exemplary! God bless! God bless! God bless! Thanks, Hui.

Hello friends...... In worksheet #1 column A i have names of 15 senior sales reps. In col B are sales totals for the month against each name. Then i do a Conditional Format for the Top5. (There are no duplicates). Can i plot a chart ONLY for the Top5 directly based on CF ? Thank you.

In a budget vs actual exercise in Excel, I would like an Excel formula to pop out a pop-up box if actual exceeds budget numbers. For instance, expenses for Selling may exceed the budgeted number for the month. E.g. If a Selling expense is being booked and the cumulative actual for the month...

Thank you, Bob. That is great.

I am doing the following report. In worksheet #1 i have my data and pivot table. I would like to pivot the data in such a way that IN...... sheet#2 i have sales by products, sheet#3 i have sales by buyers, sheet#4 i have sales by region, and so forth. Do i have to copy/paste the data-range from...

Many thanks Sathish and Khalid for ur solutions. Also thank u 4 the file, Khalid. That was interesting. Here's a solution i thought i'd share....... The simplest solution i got so far is to use the top/bottom Rules. Top 10 items which you change to 1, and Bottom 10 items which you change to 1...

I have a range of sales values for a month. Using the MAX and MIN functions i can easily find out the MAX & MIN values. What formula must i use in Conditional Formatting to color-format the MAX and MIN values using the 2-color scale option. Thank you, friends.

Thanks, Som.

Hello guys..... Sorry about the incompleteness. Here's one solution..... Select the cells, replace "1" with "$1" with the help of "Find & Replace". Thank you for the interest shown.

A formula repeats itself 26 times in cells A1 thru' Z1 by dragging across or paste special. Values are in cells A2 thru' Z2. Now I lock row 1 in col A with the $ sign. The formula now reads…......A$1 (instead of A1). But I would also like the $ sign to 'auto-appear' in the remaining 25...

Thanks, Som. That worked very well.

I was doing a 5 year trend analysis 2009 thru 2013 and I entered the years as follows: 2009 2010 2011 2012 2013 in cells J25 thru N25 But I should have entered the years as: 2013 2012 2011 2010 2009 I tried to sort the years in descending order but Excel wouldn't respond. So, I had 2 choices- 1...

Thanks, Som.......i just cracked it with CF......Highlight Cells Rules......Equal To.....and give a Formula (=$G$2) Its interesting to see a single cell get hi-lighted (with the same colour) anywhere in the range every time the data in the 'reference cell' (G2) is changed. Cheers!

Yes......and thanks.

Thanks, Somendra. I've done that. I would like 'that' cell to get hi-lighted in the range. Thanks, again.

I have a range of cells that covers months and regions. Col A2:A13 define the months Jan thru Dec. Row B2:E4 define the regions East, North, South, West. I select the range and do a Insert --> Name --> Create…..... and the default Top Row & Left Column are selected. If I want to lookup the sales...

Thanks, Somendra. That was quick. I'm trying it out. Thanks again.

Cells c6:c50 contain some numeric values. I select c6, c7, c15, c33, c35, c39 and fill-color these cells with the color yellow. In cell C51 i want a summation of only the cell values that have the color yellow. What Excel formula can do the needful. Thank you.

The Mac i use is- OS X Version 10.9.2 It works very well on mine. Sorry guys.

Thanks, Luke; that was so prompt. I like the first choice (for obvious reasons). Much appreciated.

When it comes to tolerances, numbers may have to be entered in millions. Format Cells --> Custom --> 000000 is what i did. If i enter the number 1 Excel displays 000001 in the cell F2 If i enter the number 12 Excel displays 000012 in cell F3 and so forth. But my desired output is - 0.000001 or...

Hello Hui......on my Mac its the 'command' button on the left hand side of the keyboard. Cheers

I keyed in =SUMPRODUCT() on my Mac in a cell and hit Cmd+A and Excel displayed 1048576 which is exactly the number of rows in my Excel worksheet.

Thank you, Mr. Hui. I got the ratios 'directly' by using your formula: =SUBSTITUTE(TEXT(A6/B6,"00/00"),"/",":") So, instead of the fraction 11/24 i directly got the desired ratio 11:24. Much appreciated & thanks again.