About Us

K[_2_]

On Nov 14, 12:53*pm, "Arvi Laanemets" wrote:
Hi

Another formula for B2 is
=IF(A2="","",SUM(B1,--(A2<A1)))
(Copy formula down - and you can have pre-prepared cells with formula there
too)

Arvi Laanemets

"K" wrote in message

...

Hi all, *I have data in column A (see below)

ROW * * * * * *A---------Column
1 * * * * * * *Heading
2 * * * * * * *BTC
3 * * * * * * *BTC
4 * * * * * * *BTC
5 * * * * * * *GIS
6 * * * * * * *GIS
7 * * * * * * *VXZ
8 * * * * * * *VXZ
9 * * * * * * *BTC
10 * * * * * *BTC

I want macro on button which should produce result in column B
something like (see below)

ROW * * * * * *A * * * * * * * * B---------Columns
1 * * * * * * *Heading * Heading
2 * * * * * * *BTC * * * * * * * * 1
3 * * * * * * *BTC * * * * * * * * 1
4 * * * * * * *BTC * * * * * * * * 1
5 * * * * * * *GIS * * * * * * * * *2
6 * * * * * * *GIS * * * * * * * * *2
7 * * * * * * *VXZ * * * * * * * * *3
8 * * * * * * *VXZ * * * * * * * * *3
9 * * * * * * *BTC * * * * * * * * 4
10 * * * * * *BTC * * * * * * * * 4

In other words I want macro to check in column A cells and put numbers
in column B cells and when where value become different in column A
cells then it should also change the value in column B cells. *Please
can any friend can help.- Hide quoted text -

- Show quoted text -

thanks guys

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
To get an average of a column of numbers not zero/blank cells	Neil	Excel Worksheet Functions	4	June 22nd 08 02:57 PM
Display cells(text) in one column based on cells which are present inother column	[email protected]	Excel Discussion (Misc queries)	1	May 12th 08 01:40 PM
Copying a column of single cells into a column of merged cells	[email protected]	Excel Discussion (Misc queries)	1	August 16th 06 01:18 PM
How can I change column numbers back to column letters?	Space Elf	Excel Worksheet Functions	3	March 2nd 06 09:35 PM
How do I identify cells with matching numbers within a column.	dbmeyer	Excel Worksheet Functions	6	February 26th 06 10:33 PM

Menu

About Us