Dear Experts,
Kindly Help on urgent basis to get it resolve as below .
suggest any formula to get the exact data as i required. reference sheet
attached
I have data as below source 1 1 1 1 1 1 1 1 1 1 1 1 RAKESH A
B C DMUKESH A B C D E GAURAV A B
when you select your blank cells just see the buttons in home tab where
insert,delete,format button is showing you need to press delete -delete
cells - shift cells to left .
On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
Thanks Mandeep ji,
but dear i didn't under
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 Mandeep
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
Thanks Mandeep ji,
but dear i didn't under stand what your are talking about this line
*go into home tab delete cells and shift cells left you will get your data*
Pl help
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu Kashmir,
Thanks alot Mandeep ji.
its working.
br//
rakesh
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
which cells you want to unmerge ??? Please clear that on which column you
need to check your physician Text. ??? Elaborate your query please as my
macro works for column 1
On Wednesday, May 6, 2015 at 11:44:50 AM UTC+5:30, Sundarvelan wrote:
Please find the attached file for your reference.
Select b3:m5 press f5 - click special option-tick blank-go into home
tab delete cells and shift cells left you will get your data.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
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
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 @
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 divake...@gmail.com 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
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
This non array formula should also work
=MATCH(aaa ~*,A1:A2,0)
On Wed, May 6, 2015 at 6:36 PM, Divaker Pandey divake...@gmail.com 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
13 matches
Mail list logo