Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-20 Thread Abhishek Jain
Please elaborate your query and send a sample file, if possible. On Mon, Sep 21, 2015 at 9:12 AM, Pramod Singh wrote: > Hi Expert. > > Q. (*Pramod Bisht) > Need to get:- (Pramod Bisht) > > By Text formula... > > Pramod > On 19 Sep 2015 17:54, "nyree" wrote: > >> Hello Abhishek >> >> That's pe

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-20 Thread Pramod Singh
Hi Expert. Q. (*Pramod Bisht) Need to get:- (Pramod Bisht) By Text formula... Pramod On 19 Sep 2015 17:54, "nyree" wrote: > Hello Abhishek > > That's pefect! Thank you so much for your quick response > Regards > Nyree > > > On 19-Sep-15 2:20 PM, Abhishek Jain wrote: > > Please see attached > >

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread nyree
Hello Abhishek That's pefect! Thank you so much for your quick response Regards Nyree On 19-Sep-15 2:20 PM, Abhishek Jain wrote: Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams > wrote: Hello I would like to know if it

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread Abhishek Jain
Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams wrote: > Hello > I would like to know if its possible to use a macro or forumula to replace > every "0" with the header cell value and list each one by student > eg Student B: Q107, Q108, Q110 > > Many thanks for yo

$$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread N .williams
Hello I would like to know if its possible to use a macro or forumula to replace every "0" with the header cell value and list each one by student eg Student B: Q107, Q108, Q110 Many thanks for your help Nyree English_Group *Q101* *Q102* *Q103* *Q104* *Q105* *Q106* *Q107* *Q108* *Q109* *Q110*