Jun 2012 04:03:24
To:
Reply-To: joseph.cam...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: extract data from table
Great Noorain and Seraj,
Will revert if incase of any issue.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Seraj Alam
Sender: excel-macros
: extract data from table
Hi
You can use below formula also...
=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")
On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:
> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
&g
Hi
You can use below formula also...
=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")
On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:
> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
> =IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)
Dear Joseph,
Please find attached sheet, Hope it will help to you.
for Column Heading
=IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$11<>0),COLUMN($B$1:$S$1),""),COLUMN(B1))-1),"")
For Numbers without 0
=IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),"")
--
Thanks & r
Hi Joseph,
Do you want this done with formula or Vba script?
Pascal
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick atte
Can you also give me an option if my number of rows change.
On Wed, Jun 6, 2012 at 1:18 AM, joseph camill wrote:
> yes, the number of rows and columns will be the same, but the values in it
> may change.
>
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
>
>> Hi,
>>
>> Is your table going to be t
yes, the number of rows and columns will be the same, but the values in it
may change.
On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
> Hi,
>
> Is your table going to be the same? I mean the number of columns and rows
> going to be same??
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph
