Re: $$Excel-Macros$$ Querry production analysis

Appreciate acknowledgement.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Dec 4, 2014 at 11:41 AM, Nemi Gandhi wrote: > Dear Vaibhav, > > Thanks the solution is very good. > > Nemi Gandhi > > On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi wrot

Re: $$Excel-Macros$$ Querry production analysis

Dear Vaibhav, Thanks the solution is very good. Nemi Gandhi On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi wrote: > Hi > > You can do using PVT table, check this... > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Mon, Dec 1, 2014 at 1:46

Re: $$Excel-Macros$$ Querry production analysis

Hi Vaibhav Bhai, It's Simple and Superb Solution. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

RE: $$Excel-Macros$$ Querry-serial no

PFA, r u looking for this...? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Tuesday, November 05, 2013 11:23 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Querry-serial no A excel sheet is

$$Excel-Macros$$ Querry-serial no

A excel sheet is attached. Please provide me solution to it. Thanks -- Nemi Gandhi 98204 92963 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ querry

  Please see my corrected macro solution? > > >> Don Guillett > >> SalesAid Software > >> dguille...@gmail.com > > >>  *From:* Nemi Gandhi > >> *Sent:* Thursday, October 20, 2011 1:51 AM > >> *To:* excel-macros@googlegroups.com > >

Re: $$Excel-Macros$$ querry

Hello Nemi; You can also use simple HLOOKUP. =HLOOKUP(C2,I$3:T$105,MATCH(A2,H$3:H$105,0)+B2,0) C2, here column heading & B2 is the row values located in Col_H HTH Haseeb -- -- Some important links for excel users:

Re: $$Excel-Macros$$ querry

macro solution? >>> >>> >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Nemi Gandhi >>> *Sent:* Thursday, October 20, 2011 1:51 AM >>> *To:* excel-macros@googlegroups.com >>> *S

Re: $$Excel-Macros$$ querry

ent:* Thursday, October 20, 2011 1:51 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ querry >> >> Thanks Ashishbhai and Noorainbhai, but i made little mistake in asking >> query and is posted agains. The result i want is if A2=surya or chandra

Re: $$Excel-Macros$$ querry

tt > SalesAid Software > dguille...@gmail.com > > *From:* Nemi Gandhi > *Sent:* Thursday, October 20, 2011 1:51 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ querry > > Thanks Ashishbhai and Noorainbhai, but i made little mistake in asking > qu

Re: $$Excel-Macros$$ querry

Dear Nemi, Please see attached sheet with Solution as per your requirement. i hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Th

$$Excel-Macros$$ querry

Thanks Ashishbhai and Noorainbhai, but i made little mistake in asking query and is posted agains. The result i want is if A2=surya or chandra or mangal or budh or guru or shukra or shani, look for value in appropriate table and get result. -- Nemi Gandhi 98204 92963 --

Re: $$Excel-Macros$$ querry ncg

Dear Nemi, Please try below formula and see attached sheet.. {=OFFSET(INDEX($I$3:$T$3,MATCH(C2,$I$3:$T$3,0)),MATCH(B2,$H$4:$H$15,0),0)} -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ querry ncg

=INDEX($H:$AA,MATCH(A2,H:H,0)+B2,MATCH(C2,$H$3:$T$3,0)) On Wed, Oct 19, 2011 at 12:41 PM, Nemi Gandhi wrote: > attached sheet. Please provide formula and vab code if possible. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -

$$Excel-Macros$$ querry ncg

attached sheet. Please provide formula and vab code if possible. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Querry ncg

Sub test() Dim i As Long, j As Long, k As Long ' change 3 with the row no from which ur data is starting j = 222 For i = 222 To Range("j65356").End(xlUp).Row splt = Split(Application.WorksheetFunction.Trim(Range("k" & i).Value)) For k = LBound(splt) To UBound(splt) Sheets(1).Range("l" & j).V

Re: $$Excel-Macros$$ Querry ncg

Freinds, In the querry worksheet, the data was in b3 and c3 and result is generated from e3 and f3 , but in actual, my data is available in column J222 and k222 in sheet named "kundali" , and i tried to change the range in Macro but failed. Hence, please send me the details as to where i should c

Re: $$Excel-Macros$$ Querry ncg

Thanks excel macro freinds. Nemi Gandhi On Oct 8, 8:46 pm, ashish koul wrote: > check the attachment > > > > > > > > > > On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote: > > Plaease provide solution. > > > -- > > Nemi Gandhi > > 98204 92963 > > >  -- > > >

Re: $$Excel-Macros$$ Querry ncg

I suggest simply selecting your name cells in col B>data>text to columns>space>finish Don Guillett SalesAid Software dguille...@gmail.com From: Nemi Gandhi Sent: Saturday, October 08, 2011 4:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Querry ncg Pla

Re: $$Excel-Macros$$ Querry ncg

check the attachment On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote: > Plaease provide solution. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER

$$Excel-Macros$$ Querry ncg

Plaease provide solution. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ htt

Re: $$Excel-Macros$$ querry 5

try this Option Base 1 Sub nemi() Dim s(5) As String Dim z As Long s(1) = "Very Good" s(2) = "Good" s(3) = "Better" s(4) = "Bad" s(5) = "Very Bad" For i = 1 To 5 On Error Resume Next Sheets(1).ShowAllData z = Sheets(1).Range("f65356").End(xlUp).Row + 1 Sheets(1).Range("$A$3:$e$" & Sheets(1).Ra

Re: $$Excel-Macros$$ querry 5

hi Nemi Gandhi use this formula in cell F4 of your table and than sort it by column F shortest to largestyou will table as per your need *=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5* Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'

$$Excel-Macros$$ querry 5

Formula needed please. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

Re: $$Excel-Macros$$ querry 4

your formula will come in this form =IF(AND(E5>=60,D5>=60),D3+D4+1-60,"") On Mon, Jun 20, 2011 at 6:15 PM, Nemi Gandhi wrote: > please see the attached file. Please help. > > -- > Nemi Gandhi > 98204 92963 > > -- > > --

$$Excel-Macros$$ querry 4

please see the attached file. Please help. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Lin

Re: $$Excel-Macros$$ querry 3

Envoyé : vendredi 17 juin 2011 08:28 > À : excel-macros@googlegroups.com > Objet : $$Excel-Macros$$ querry 3 > > attached once again for some correction and explanation for my knowledge. > > -- > Nemi Gandhi > 98204 92963 > > -- >

RE: $$Excel-Macros$$ querry 3

See attached file. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : vendredi 17 juin 2011 08:28 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ querry 3 attached once again for some correction and explanation

RE: $$Excel-Macros$$ querry 3

See attached file. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : vendredi 17 juin 2011 08:28 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ querry 3 attached once again for some correction and explanation

RE: $$Excel-Macros$$ querry 3

I have trouble understanding ; can you post which result is expected ? Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : vendredi 17 juin 2011 08:28 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ querry 3

Re: $$Excel-Macros$$ querry-3

cel-macros@googlegroups.com] De > la part de Nemi Gandhi > Envoyé : jeudi 16 juin 2011 13:02 > À : excel-macros@googlegroups.com > Objet : $$Excel-Macros$$ querry-3 > > Dear Members, > i need the

$$Excel-Macros$$ querry 3

attached once again for some correction and explanation for my knowledge. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.co

RE: $$Excel-Macros$$ querry-3

See attached file. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : jeudi 16 juin 2011 13:02 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ querry-3 Dear Members, i need the formula please

RE: $$Excel-Macros$$ querry-3

See if it help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Thursday, June 16, 2011 4:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ querry-3 Dear Members, i need the formula please.. -- Nemi Gandhi 98204

$$Excel-Macros$$ querry-3

Dear Members, i need the formula please.. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

Re: $$Excel-Macros$$ querry new

> la part de Nemi Gandhi > Envoyé : mercredi 15 juin 2011 08:44 > À : MS EXCEL AND VBA MACROS > Objet : Re: $$Excel-Macros$$ querry new > > Thank you Daniel, but when i  drag the formula to other cells in column > D22:022, , it whows 'YES". Only J22 column should show &quo

RE: $$Excel-Macros$$ querry new

Maybe this file ? Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : mercredi 15 juin 2011 08:44 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$ querry new Thank you Daniel, but when i

Re: $$Excel-Macros$$ querry new

m] De > la part de Nemi Gandhi > Envoyé : mardi 14 juin 2011 13:47 > À : excel-macros@googlegroups.com > Objet : $$Excel-Macros$$ querry new > > file is attached. i need formula please. > > -- > Nemi Gandhi > 98204 92963 > > -- > ---

RE: $$Excel-Macros$$ querry new

Have a look at the attached file. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : mardi 14 juin 2011 13:47 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ querry new file is attached. i need formula please

$$Excel-Macros$$ querry new

file is attached. i need formula please. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linke

Re: $$Excel-Macros$$ querry

Thanks Siti, Ranjan for sharing useful information On Mon, Apr 11, 2011 at 1:25 PM, rajan verma wrote: > *"=_xlfn shows that the following Fuction exist in higher Version of excel > but not in Lower Version.. Exce Automatically Include =_xlfn .. when file > open in Lower Version of Excel,,* > >

Re: $$Excel-Macros$$ querry

*"=_xlfn shows that the following Fuction exist in higher Version of excel but not in Lower Version.. Exce Automatically Include =_xlfn .. when file open in Lower Version of Excel,,* On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan wrote: > Dear Ashish, > > Pl. explain what is *"=_xlfn."*SUMIFS

Re: $$Excel-Macros$$ querry

_xlfn IS http://office.microsoft.com/en-us/excel-help/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-HA010204569.aspx On Sat, Apr 9, 2011 at 11:02 PM, Dhananjay Pinjan wrote: > Pl. explain what is *"=_xlfn*."??? > Is it User Defined function or what else? > > Regards, > Dhanajay >

Re: $$Excel-Macros$$ querry

Pl. explain what is *"=_xlfn*."??? Is it User Defined function or what else? Regards, Dhanajay On Sat, Apr 9, 2011 at 9:22 PM, ashish koul wrote: > sumifs function is avaliable in excel 2007 onwards check out the link below > > > http://office.microsoft.com/en-us/excel-help/sumifs-function

Re: $$Excel-Macros$$ querry

sumifs function is avaliable in excel 2007 onwards check out the link below http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan wrote: > Dear Ashish, > > Pl. explain what is *"=_xlfn."*SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D

Re: $$Excel-Macros$$ querry

Dear Ashish, Pl. explain what is *"=_xlfn."*SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5) Regards, Dhananjay On Sat, Apr 9, 2011 at 4:07 PM, ashish koul wrote: > see if it helps > > > On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi wrote: > >> Please reply. >> >> -- >> Nemi Gandhi >> 98204 92963

Re: $$Excel-Macros$$ querry

Hi Nemi find attach On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi wrote: > Please reply. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ querry

see if it helps On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi wrote: > Please reply. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks an

$$Excel-Macros$$ querry

Please reply. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.link

RE: $$Excel-Macros$$ QUERRY

-Macros$$ QUERRY PLEASE HELP. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

Re: $$Excel-Macros$$ QUERRY

One could be this solution(attached)... Regards, Manoj Kumar On Mon, Jan 31, 2011 at 6:22 PM, ashish koul wrote: > check the attachment > > > On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi wrote: > >> PLEASE HELP. >> >> -- >> Nemi Gandhi >> 98204 92963 >> >> -- >> >> --

Re: $$Excel-Macros$$ QUERRY

Dear Nemi, Please find attached sheet with solution.. -- Thanks & regards, Noorain Ansari On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi wrote: > PLEASE HELP. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some i

Re: $$Excel-Macros$$ QUERRY

check the attachment On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi wrote: > PLEASE HELP. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tric

$$Excel-Macros$$ QUERRY

PLEASE HELP. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linke

$$Excel-Macros$$ Querry !

Can anyone tell me how can I hide row and column heading?... I mean calumn names for example a.b.c.d in default and row names 1 2 3 etc. Regards _ Show them the way! Add maps and directions to your party invites. http://ww

$$Excel-Macros$$ Querry regding OpenXL

One problem using Open XL... Once any function in OpenXL is used it can't be undone using Ctr+Z . Plz solve this querry On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > If you want to do any or all of the following. Visit > http://www.excelitems.com > and Down