Hi Prafull,
Rept :- Rept function return a repeated text value a specified number of
times
you can also use lookup with Rept formula for last text
"=LOOKUP(REPT("z",255),G10:G23)"
Rept :- Repeats text a given number of times. Use REPT to fill a cell with
a number of instances of a text string.
Dear Xls Sir,
Can you explain the below formula.
When we used Lookup formula and Rept .
Why you have mention in formula "Z" and 255 ?
Thanks in Advance .
Regards,
Prafull Jadhav.
On Thu, Apr 11, 2013 at 10:56 PM, Gum Nam wrote:
> HI,
> Thanks, I tried your formula it gave me an error N/A
>
HI,
Thanks, I tried your formula it gave me an error N/A
On Wed, Apr 10, 2013 at 11:26 PM, xlstime wrote:
> Hi Shaukheen,
>
> Please try below formula
> For text =INDEX(F5:F11,MATCH(REPT("z",255),F5:F11))
> For Number =LOOKUP(9.99E+22,F5:F11)
>
> .
>
> Enjo
Hi Shaukheen,
Please try below formula
For text =INDEX(F5:F11,MATCH(REPT("z",255),F5:F11))
For Number =LOOKUP(9.99E+22,F5:F11)
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 3:51 AM, wrote:
>
>
> I have a sheet with lot IDs in Col A
>
>
> AAA100
> CPP100
> AAA1
