Recent content by James Perry

Somendra....... I hope that tiny sample will suffice. Thanks, anyways

Thanks bobhc...that's a cool reply. But i'm not looking at a Table or Pivot Table as a solution. Much appreciated.

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

Sorry.... i didn't know that. Thank u.

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

thank u Misra......

Hey thanks a load Somendra Misra. That's not only brilliant, that's super brilliant. I got it. First the '5 fingers'. Next the 'clenched fist'. Then the 'I.

Thanks, Khalid. That's really cool.

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