1) Vlookup with multiple returns across rows and 2) countif function

[IanGi]

Dear All,

While I understand there are a number of posts on returning multiple cells, my question relates to returning multiples returns across rows, and summing the various categories after.

As my sample below demonstrates, I am trying to lookup Trading Dates relating to a company's stock (Column C) against a large selection of Event Dates (Column B) and return any related Event Types (Column A) horizontally across rows beginning in Colum E and beyond.

The problem is that my data analyzes daily trades over the past 20 years. On many of the trading dates there are a number (often identical) event types reported. For example on 2 May 00 the company has 3 news events entitled DIVNEWS. I want ALL three of these to be displayed across columns.

Ultimately, I will be summing across the appropriate event types and utilizing dummy variables to run regressions.

Thank you very much for any advice!

Ian

<table style="border-collapse: collapse; width: 529pt;" border="0" cellpadding="0" cellspacing="0" width="705"><col style="width: 48pt;" width="64"> <col style="width: 55pt;" width="73"> <col style="width: 78pt;" width="104"> <col style="width: 62pt;" width="82"> <col style="width: 50pt;" width="66"> <col style="width: 59pt;" span="4" width="79"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl84" style="height: 15pt; width: 48pt;" height="20" width="64"> </td> <td class="xl84" style="border-left: medium none; width: 55pt;" width="73">A</td> <td class="xl84" style="border-left: medium none; width: 78pt;" width="104">B</td> <td class="xl84" style="border-left: medium none; width: 62pt;" width="82">C</td> <td class="xl84" style="border-left: medium none; width: 50pt;" width="66">D</td> <td class="xl84" style="border-left: medium none; width: 59pt;" width="79">E</td> <td class="xl84" style="border-left: medium none; width: 59pt;" width="79">F</td> <td class="xl84" style="border-left: medium none; width: 59pt;" width="79">G</td> <td class="xl84" style="border-left: medium none; width: 59pt;" width="79">H</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl84" style="height: 30pt; border-top: medium none; width: 48pt;" height="40" width="64">2</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">Event Type</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 78pt;" width="104">Event Date</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 62pt;" width="82">Trading Date</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 50pt;" width="66">Excess Return</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">Event 1</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">Event 2</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">Event 3</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">Event n ….</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl84" style="height: 30pt; border-top: medium none; width: 48pt;" height="40" width="64">3</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">MNGT</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 78pt;" align="right" width="104">10-Aug-09</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 62pt;" align="right" width="82">17-May-91</td> <td class="xl88" style="border-top: medium none; border-left: medium none; width: 50pt;" align="right" width="66">0.00%</td> <td class="xl89" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">ER</td> <td class="xl89" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">ER</td> <td class="xl89" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">MNGT</td> <td class="xl89" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79">DIVNEWS</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl84" style="height: 15.75pt; border-top: medium none; width: 48pt;" height="21" width="64">4</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">ER</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 78pt;" align="right" width="104">10-Aug-09</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 62pt;" align="right" width="82">20-May-91</td> <td class="xl88" style="border-top: medium none; border-left: medium none; width: 50pt;" align="right" width="66">0.01%</td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl84" style="height: 15.75pt; border-top: medium none; width: 48pt;" height="21" width="64">5</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">ER</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 78pt;" align="right" width="104">10-Aug-09</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 62pt;" align="right" width="82">21-May-91</td> <td class="xl88" style="border-top: medium none; border-left: medium none; width: 50pt;" align="right" width="66">-0.14%</td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl84" style="height: 15.75pt; border-top: medium none; width: 48pt;" height="21" width="64">6</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">MNGT</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 78pt;" align="right" width="104">10-Aug-09</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 62pt;" align="right" width="82">22-May-91</td> <td class="xl88" style="border-top: medium none; border-left: medium none; width: 50pt;" align="right" width="66">0.12%</td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl84" style="height: 30pt; border-top: medium none; width: 48pt;" height="40" width="64">7</td> <td class="xl86" style="border-top: medium none; border-left: medium none; width: 55pt;" width="73">DIVNEWS</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 78pt;" align="right" width="104">10-Aug-09</td> <td class="xl87" style="border-top: medium none; border-left: medium none; width: 62pt;" align="right" width="82">23-May-91</td> <td class="xl88" style="border-top: medium none; border-left: medium none; width: 50pt;" align="right" width="66">0.66%</td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> <td class="xl85" style="border-top: medium none; border-left: medium none; width: 59pt;" width="79"> </td> </tr> </tbody></table>

 

[Akashwani]

Hi Ian,

Welcome to MrExcel.

What are you actually looking up?
Is it a particular Date, Month or Year?

Is this something like you want to achieve?.....

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Event Type	Event Date	Trading Date	Excess Return	3	Event 1	Event 2	Event 3	Event 4
2	MNGT	10-Aug-09	17-May-91	0.00%	21-May-91	ER	DIVNEWS	TEST	*
3	ER	10-Aug-09	20-May-91	0.01%	4.69%	-0.14%	1.81%	3.01%	*
4	ER	10-Aug-09	21-May-91	-0.14%	*	*	*	*	*
5	MNGT	10-Aug-09	22-May-91	0.12%	*	*	*	*	*
6	DIVNEWS	10-Aug-09	23-May-91	0.66%	*	*	*	*	*
7	ER	10-Aug-09	24-May-91	1.01%	*	*	*	*	*
8	MNGT	10-Aug-09	25-May-91	1.41%	*	*	*	*	*
9	DIVNEWS	10-Aug-09	21-May-91	1.81%	*	*	*	*	*
10	ER	10-Aug-09	27-May-91	2.21%	*	*	*	*	*
11	MNGT	10-Aug-09	28-May-91	2.61%	*	*	*	*	*
12	TEST	10-Aug-09	21-May-91	3.01%	*	*	*	*	*
13	ER	10-Aug-09	30-May-91	3.41%	*	*	*	*	*
14	MNGT	10-Aug-09	31-May-91	3.81%	*	*	*	*	*
15	DIVNEWS	10-Aug-09	01-Jun-91	4.21%	*	*	*	*	*
16	ER	10-Aug-09	02-Jun-91	4.61%	*	*	*	*	*
Sheet3

The formulas in F2, F3 need entering with ctrl shift enter NOT enter.
You can then copy the formulas across as far as you require.

I hope that helps you.

Ak

 

[IanGi]

Dear Akashwani,

Thank you very much for getting back to me. I apologize but my original post was not clear. Let me try and recreate (without the formulas!) what I was ultimately hoping for.


I need to match events that took place on trading dates and return in a list across rows each respective event that took place on a given trading date.



For example, when I look up 17-May-91 from Column C in Column B, I want all matching event types for the 17-May-91 to display in Columns F, G, H etc...(as many columns as required).



From the example here, this would mean that from Column B I have 3 matching event types for the trading date 17-May-91 including ER, MNGT and another ER (A3, A5, A13 respectively). F2 would then return ER, G2 would return MNGT and H would return ER.


The next lookup would be for C3 for the trading date 20 May 91. This would find A2=MNGT, A6=DIVNEWS, A9=DIVNEWS and A10=ER, . As a result, these labels (MNGT, DIVNEWS, DIVNEWS and ER) would be returned in F3, G3, H3, and I3 respectively.



As noted, I am looking at roughly 20 years of daily trading data for a companys stock. The intention is to analyze on which trading days events took place. Whena trading day is found for which an event took place, I want the respective event type (i.e. MNGT, ER etc) to be displayed across rows. The point is that while vlookup would work for a single event, there are certain trading dates that have saw 10 events. I need all 10 of the events to be returned across the row corresponding to the appropriate trading date. Later these various categories will be summed up and regressions can be used to analyze the significance of the the excess returns.



Please let me know if this is still unclear!


<table border="0" cellpadding="0" cellspacing="0"><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>*</td><td>A</td><td>B</td><td>C</td><td>D</td><td>F</td><td>G</td><td>H</td><td>I</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">1</td><td style="font-weight:bold; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event Type</td><td style="font-weight:bold; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event Date</td><td style="font-weight:bold; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Trading Date</td><td style="font-weight:bold; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Excess Return</td><td style="font-weight:bold; text-align:center; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event 1</td><td style="font-weight:bold; text-align:center; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event 2</td><td style="font-weight:bold; text-align:center; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event 3</td><td style="font-weight:bold; text-align:center; border-bottom-style:solid; border-width:1px; border-color:#000000; ">Event n ...
</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">2</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">20-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">17-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">0.00%</td><td style="font-weight:bold; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="font-weight:bold; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="font-weight:bold; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="font-weight:bold; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">N/A</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">3</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">17-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">20-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">0.01%</td><td style="font-weight:bold; text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">MNGT
</td><td style="font-weight:bold; text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">DIVNEWS
</td><td style="font-weight:bold; text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">DIVNEWS</td><td style="font-weight:bold; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">ER
</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">4</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">21-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">-0.14%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">5</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">17-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">22-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">0.12%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">6</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">DIVNEWS</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">20-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">23-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">0.66%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">7</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">24-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">1.01%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">8</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">25-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">1.41%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">9</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">DIVNEWS</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">20-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">21-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">1.81%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">10</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">20-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">27-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">2.21%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">11</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">28-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">2.61%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">12</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">TEST</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">21-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">3.01%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">13</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">ER</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">17-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">30-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">3.41%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">14</td><td style=" border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-width:1px; border-color:#000000; ">MNGT</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">10-Aug-09</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">31-May-91</td><td style="text-align:right; border-right-style:solid; border-bottom-style:solid; border-width:1px; border-color:#000000; ">3.81%</td><td>*</td><td>*</td><td>*</td><td>*</td></tr></tbody></table>

 

[Akashwani]

Hi Ian,

Is this what you require?....

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Event Type	Event Date	Trading Date	Excess Return	count	Event 1	Event 2	Event 3	Event 4
2	MNGT	20-May-91	17-May-91	0.00%	3	ER	MNGT	ER	*
3	ER	17-May-91	20-May-91	0.01%	4	MNGT	DIVNEWS	DIVNEWS	ER
4	ER	10-Aug-09	21-May-91	-0.14%	0	*	*	*	*
5	MNGT	17-May-91	22-May-91	0.12%	0	*	*	*	*
6	DIVNEWS	20-May-91	23-May-91	0.66%	0	*	*	*	*
7	ER	10-Aug-09	24-May-91	1.01%	0	*	*	*	*
8	MNGT	10-Aug-09	25-May-91	1.41%	0	*	*	*	*
9	DIVNEWS	20-May-91	21-May-91	1.81%	0	*	*	*	*
10	ER	20-May-91	27-May-91	2.21%	0	*	*	*	*
11	MNGT	10-Aug-09	28-May-91	2.61%	0	*	*	*	*
12	TEST	10-Aug-09	21-May-91	3.01%	0	*	*	*	*
13	ER	17-May-91	30-May-91	3.41%	0	*	*	*	*
14	MNGT	10-Aug-09	31-May-91	3.81%	0	*	*	*	*
Sheet1

The formula in E2 needs to be copied down as far as you require.
The formula in F2 need entering with ctrl shift enter NOT enter.
You can then copy it across and down as far as you require.

Remember to change the cell references to suit you data range.

I hope this works for you.

Good luck.

Ak

 

[IanGi]

Thank you Thank you Thank you! This is a tremendous help

 

[Akashwani]

Hi Ian,

You are welcome, thanks for the feedback, it's good to know a solution has worked.

Good luck with your project and you now know where to look if you have any Excel problems.

Ak