Re: $$Excel-Macros$$ Split with formula

2013-05-10 Thread Prafull Jadhav
2013 9:51 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Split with formula ** ** Hi Priti, ** ** Sorry for the late reply., Thanks for the formula provided, really its a very new things for me and learning tips. ** ** Ok, Can we make in only one

$$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
Dear experts, I want to split the below string into seperate numbers. Example: 15.00,63.23,18.00 i want into as : 15.00 63.23 18.00 After seperation, i want the min number of those three number. Please find the attachment for more example i have use Text to Coloumns, but i want in

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Shaik Waheed
PFA sheet solved, You can split your data by using text to columns wizard and selecting comma in the options. One done with this you will data splitted in mutliple columns, now give a min formula for the beside row, it will give u minimum value, drag it down till the data is available. Once done,

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
Thanks Waheed, Thanks for that, but i dont want to split by text to coloumns, i want with formulas in one cell. hope you got my point of query. Regards, Chaya On Thu, May 9, 2013 at 6:26 PM, Shaik Waheed waheedb...@gmail.com wrote: PFA sheet solved, You can split your data by using

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread priti verma
Hi Chaya, Pfa On Thu, May 9, 2013 at 6:30 PM, Chaya chayamon...@gmail.com wrote: Thanks Waheed, Thanks for that, but i dont want to split by text to coloumns, i want with formulas in one cell. hope you got my point of query. Regards, Chaya On Thu, May 9, 2013 at 6:26 PM, Shaik

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
Hi Priti, Sorry for the late reply., Thanks for the formula provided, really its a very new things for me and learning tips. Ok, Can we make in only one formula to find the min number in my attached file earlier ? Or else can we seperate the number seperately without array formula in your

RE: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Priti_verma
Hi chaya , Yes you can do it.Please see the attached file . From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chaya Sent: 10 May 2013 9:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Split with formula Hi Priti, Sorry

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
[mailto: excel-macros@googlegroups.com] *On Behalf Of *Chaya *Sent:* 10 May 2013 9:51 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Split with formula ** ** Hi Priti, ** ** Sorry for the late reply., Thanks for the formula provided, really its a very new

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread priti verma
can do it.Please see the attached file .* * * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chaya *Sent:* 10 May 2013 9:51 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Split with formula ** ** Hi Priti

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
] *On Behalf Of *Chaya *Sent:* 10 May 2013 9:51 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Split with formula ** ** Hi Priti, ** ** Sorry for the late reply., Thanks for the formula provided, really its a very new things for me and learning tips