I ended up replacing " - " with "*" and then used "*" as the deliminator
On Friday, November 6, 2015 at 10:04:57 AM UTC-5, drew...@gmail.com wrote:
>
> Hello,
>
> I would be very grateful if someone could provide a formula for dividing
> text to columns using " - " as a deliminator.
>
> Many Than
om
Subject: Re: $$Excel-Macros$$ Re: Need excel formula
Dear Excel Guru,
Please find the attached file,
If ptp1 comes which date ptp generated that date should comes in D2 cell, I
want all colored cells for formula..
Thanks & Regards,
Sriram G (Chennai)
On Fri, Jun 29,
Dear Excel Guru,
Please find the attached file,
If ptp1 comes which date ptp generated that date should comes in D2 cell, I
want all colored cells for formula..
Thanks & Regards,
Sriram G (Chennai)
On Fri, Jun 29, 2012 at 12:37 PM, Lalit_Mohan wrote:
> Hi Sriram,
>
> Could you please explai
use this in D14 and Paste in All Cells :
=IFERROR(INDEX($H$13:$N$13,1,LARGE(--($H14:$N14=D$13)*COLUMN($H$13:$N$13),1)-7),"")
Rajan.
On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:
>
> Dear Excel Guru,
>
> Please find the attached file and help me
>
>
>
> Thanks & Regards,
>
Hi Sriram,
Could you please explain excatly what you are looking for so that we can
provide you the solution related to the query.
Regards,
Lalit Mohan
On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:
>
> Dear Excel Guru,
>
> Please find the attached file and help me
>
>
>
> Than
http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm
On Dec 12, 2:14 am, amrahs k wrote:
> Dear Experts,
>
> I have described my query in the attached workbook. I need excel formula or
> any appropriate function to solve my query.
>
> Please help me on this.
>
> Looking forward t
Brilliant! Thanks for your support Ayush.
Best Regards,
Sharma
On Sun, Dec 12, 2010 at 1:35 PM, Ayush wrote:
> Dear Sharma,
>
> Attached is the solution. I have used COUNTIFS formula to get this done.
> I hope it helps. Please let us know if any further assistance is required.
>
> Thanks.
>
> B
