Search results

I have a worksheet that contains rows of data. Column A has rows of sales data for a month. Cell A1 has the label Sales_Rep. Col B1 has the label Sales_Value. Col C1 has the label Mode_Of_Payment (Cash, Check, Card ) I do a 'remove duplicates' on column A that contains the names of sales...

A simple example. A company has 12 sales depots in the township. Sales revenue data pours in each month for all 12 depots. So at the year end there are 144 rows of sales data with each depot name appearing 12 times. So how do I compute the TOTAL sales for each depot ??? Here'a how.... In a new...

Hello friends. If I key in the word 'hello' in a cell that word gets left-aligned simply because it’s a text. If I key in a number like '16396' in a cell, that takes on right-alightment because it’s a number. BUT if i key in the word 'true' in a cell, Excel displays the same word but in...

In an excel worksheet are 250 values. 150 values are active. The rest are filtered out. Every time a active value is selected it is also given a color for ease of identification. The color can be the same for all 150 cells. But since Excel provides millions of colors i prefer to use a unique...

Cell A1 has the label 'email of those invited' Cell B2 has the label - RSVP'd Cell C2 has the label - Not RSVP'd Cells B2:B25 contain the email addresses of those invited who have RSVP'd Required- Cells C2:C25 to display only those who have not RSVP'd My solution: In cell C2 enter the formula -...

WISHING ONE & ALL... A VERY HAPPY NEW YEAR 2015 !!

Cell A1 has the label Emp_Name. In cell B1 i accidentally key Hours_Worked instead of Date_Worked. In cell C1 i key in Date_Worked. Now i would like to 'switch' the labels so that B1 becomes Date_Worked and C1 becomes Hours_Worked. This is the order i would like on my sheet. So i select cells B1...

A single cell is formatted to include the word 'Approved' (wherever applicable) + a budget value. Both values are in a single cell. Approved on the left and the budget value on the right. I only need to make the word 'Approved' display as a superscript. My question.... Is there a way to do the...

Cell A3 has a changing numeric value. Cell B2 has a fixed number e.g. 100 Cell B3 has the formula = INT(A3/B2) E.g. = INT(550/100) gives 5 in cell B3 What i need..... Excel formula in cell B1 (like a incremental counter) to do a summation of the values in cell B3 each time the value in cell...

I have the names of 10 students in column A and scores in column B. Each student has 10 subjects. That's 100 rows of student-data + row 1 for the labels. I put on the Filter. Next i apply the text filter for a single student. That gives 10 lines of data for a single student. Then i apply the...

In a Excel sheet i have list of outstandings. The labels in sheet1 column-wise are.... DebtorName Invoice# InvoiceDate InvoiceAmt DaysO/S PaymentStatus In sheet2 is my pivot table based on sheet1 The pivot table will only display InvoiceAmt & Days O/S Right click on Days O/S and do a...

Holding down the control key i select cells A1, B5, C8, D12, E17. Still holding down the Ctrl key i use the Fill Color to fill all 5 cells with just one color and with one mouse click. In the same way i would like to fill all 5 cells with a common text value BUT unable to do so. So i'm using 3...

I was doing a hypothetical ageing analysis of debtors. Typically one would use the =(TODAY) function as a base date even in a real-life situation. But in order to insert a fictitious date in the 'Bill Date" column i used......... =(TODAY) -10, =(TODAY) -15, =(TODAY) -20 and so forth. That way i...

MAX will display the largest number from a range of unique numbers. But i also need to find the 2nd & 3rd largest number in the same range. What xl function must i use ??? Just a wild guess...... Can the MAX function be circumvented to MAX -1 (to give the 2nd largest) and (MAX -2) to give the...

I am trying to click on QAT to insert today's date in a cell in any xl worksheet by assigning a macro to it but all get is =TODAY() when i should be getting the date instead. Can anybody please enlighten. ThankS. Is there a xl formula that can do this or is VBA the only way out. ThankS again...

I'm looking at some Excel functionality that can grab data from the web. Sometimes it becomes to grab data from the web by using some Excel functionality that can populate 'multiple' cells. For ex. i may need to grab some data of a particular stock from the GOOGLE FINANCE onto an excel sheet in...

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

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

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

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.

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

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

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

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.