Search results

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

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

Thank u Mr. Abdul.I'll stick to LARGE.

Very many thanks, Hui. Here's what i finally got. Ur valuable suggestions r most welcome. Sub todays_date Selection.Value = Date Selection.Columns.Autofit End Sub Or simply...... Sub todays_date Selection.Columns = Date End Sub In both cases xl will display 10/21/2014 in the...

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

Thank you. I'll settle for that.