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
I have a sheet with lot IDs in Col A
AAA100
CPP100
AAA101
AAA102
CPP101 and so on.
I need to find max value on AAA series or in CPP series, I can change that
to suite my needs. if there can be a vb code it would be nice.
Thank you
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo
