how is your sheet data.??? it contain a single column or multiple columns ??
On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:
>
> Hi,
>
> I need some help in modify the Macro. Current it combine multiple sheet in
> one column. I need to copy each sheet to one column,
>
> Like
This non array formula should also work
=MATCH("aaa" & "~*",A1:A2,0)
On Wed, May 6, 2015 at 6:36 PM, Divaker Pandey wrote:
> say if cell a1 contains a text
> and a2 contains aaa*
> and i used match function =match("aaa*",A1:A2",0)
> it should return 2
>
> Thanks
>
> --
> Are you =EXP(E:RT)
Try the following *Array* Formula
=MATCH(SUBSTITUTE("aaa*","*","|",1),SUBSTITUTE(A1:A2,"*","|",1),0)
On Wed, May 6, 2015 at 11:06 PM, Divaker Pandey wrote:
> say if cell a1 contains a text
> and a2 contains aaa*
> and i used match function =match("aaa*",A1:A2",0)
> it should return 2
>
> T
Hi,
I need some help in modify the Macro. Current it combine multiple sheet in
one column. I need to copy each sheet to one column,
Like
Sheet 1 to A
Sheet 2 to B
Sheet 3 to C
Sheet 4 to D
Etc..
Sub Combine()
Dim J As Integer
Dim rey As Range
On Error Resume Next
Sheets(1).Select
Worksheets.A
say if cell a1 contains a text
and a2 contains aaa*
and i used match function =match("aaa*",A1:A2",0)
it should return 2
Thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebo
check this code, One thing I must say in this sheet there are many columns
which are useless and blank, if you wish I can remove that too.
Sub Test()
Rows(1).UnMerge
ActiveSheet.Range("$AK$1:$AL$20500").AutoFilter Field:=1,
Criteria1:="Amount"
ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisib
Hi Mandeep,
I want to unmerge the rows nos 1,15,25,31,43,113,126,193,200
This may increase or decrease in my upcoming month excel hence i want to
continue merge all the header rows as much as the headers.
Thanks
N.Sundarvelan
9600160150
On Wed, May 6, 2015 at 12:06 PM, Mandeep Baluja
wrote:
Glad to help :)
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote:
>
> Thanks alot Mandee
