Re: $$Excel-Macros$$ how to search for max value in alpha neumeric range or col.

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.

$$Excel-Macros$$ Re: using autofilter in VBA to exclude items

Thanks. Seems strange that you cant do it in VBA when you can manuallly do it. Also it seems you can do it for a whole array but not if I use fewer. eg this works for another one of my spreadsheets (code I got from recording the macro) ActiveSheet.Range("$A$1:$K$1450").AutoFilter Field:=4

Re: $$Excel-Macros$$ help required

Hello, Please elaborate on this statement "I want formudata for e which is unique date agains each site" It s not clear. Thankyou On Sat, Apr 13, 2013 at 3:22 AM, Neeraj Chauhan wrote: > Dear experts, > > ** ** > > Kindly find the attached sheet > > -- > Are you =EXP(E:RT) or =NOT(E