Posted to microsoft.public.excel.misc

external usenet poster

Posts: 9

To display repetitive text, one time, auomatically

JUNE - 20
DECEMBER - 56
JUNE - 96
JUNE - 56
DECEMBER - 66

dear All, i have this data in 2 columns and what I want is:
to appear 'june' automatically in one cell and in the next cell the total of
june (172). I got 172 by using 'sumif' function, but ;june' has to appear
automatically. please help me to sort out this. thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a shortcut for repetitive text	Deej Hernandez	Excel Discussion (Misc queries)	3	October 12th 09 10:02 PM
Display time in text	Elton Law[_2_]	Excel Worksheet Functions	5	April 29th 09 10:12 AM
Auomatically updatting formula when cell is not blank	Raj	Excel Discussion (Misc queries)	3	March 28th 07 02:56 AM
if a cell contains text, then display date and time	cassandra112	Excel Discussion (Misc queries)	7	August 9th 06 10:10 PM
repetitive	Repetitive formula	Excel Discussion (Misc queries)	2	June 28th 06 05:59 AM

All times are GMT +1. The time now is 05:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us