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