$$Excel-Macros$$ Re: how to remove the symbol of drop down list

Hi, i got it, in the tab home wrote: > Hi, > > see the attachement for my prob., i made a drop down but after removing the > list the symbol of dropdown list still is there, it is by default of any > trick to remove, it is not coming in print but visible on screen > > please help > > Thanks & Reg

Re: $$Excel-Macros$$ Fwd: HAPPY MAKARSANKRANTI

धन्यवाद आप सब को भी मकर संक्रांति की शुभ कामनाये विकास गुप्ता On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora wrote: > * आपको * > * और * > * आपके * > * परिवार * > *

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks & regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul wrote: > hi > 1 case sensitive lookup using index and match

$$Excel-Macros$$ how to use " Or" in pivote table ?

I have a pivot table how to use " Or" in two columns I want to view all rows which Column1 = "cat" Or column2 = "cat" Not Column1 = "cat" AND column2 = "cat" By code or any way Thanks! -- -- Some

$$Excel-Macros$$ how to remove the symbol of drop down list

Hi, see the attachement for my prob., i made a drop down but after removing the list the symbol of dropdown list still is there, it is by default of any trick to remove, it is not coming in print but visible on screen please help Thanks & Regards ROHAN 9818247278, 8860567680 -- --

$$Excel-Macros$$ Concatenate Value Problem

Dear Group Friends, I have two work sheet. Sheet1 contain bill number in column B, and sheet2 contain bill number and PRA No in column A and column B. My problem is, I want to concatenate the PRA No. with "," for every unique bill Number. e.g. Sheet1 date are as Under: Bill No. FDN/01 FDN/02 FD

Re: $$Excel-Macros$$ Fwd: HAPPY MAKARSANKRANTI

Thanks and Wish you* Happy Makar Sankranti* to u as well Regards, Manoj Kumar On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora wrote: > * आपको * > * और * > * आपके * > * परिवार * > *

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Congratulations Dilip... :) Regds, Manish Pansari On Jan 5, 7:19 pm, Kal xcel wrote: > Hi Dilip, > > Many many congratulation to you. This group needs you. Keep it up. > > > > On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS wrote: > > Dear Mr. Dilip > > > *Congratulations to you* > > > Regards > > >

Re: $$Excel-Macros$$ Formula of the week - share your best formula

One of the function which I do like is "TRANSPOSE" function. - This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns. - The transpose range must be the same size as t

Re: $$Excel-Macros$$ IF two criteria then count occurrences of "TRUE"

Hi, see attachment hope it may help thanks & Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 8:51 PM, ashish koul wrote: > attachement missing > > On Thu, Jan 13, 2011 at 7:11 PM, mikeb wrote: > >> I would appreciate some help with the following. I am trying to use >> two crit

Re: $$Excel-Macros$$ Formula of the week - share your best formula

hi 1 case sensitive lookup using index and match 2 vlookup & indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . wrote: > Hi All, > > I suggest all of you don't say this function I like and then thi

Re: $$Excel-Macros$$ Offset Range Copy

try this Sub test() Dim i As Long ' change value of i as per your requirement i = 2 Range(ActiveCell, ActiveCell.Offset(i, 200)).Copy End Sub On Thu, Jan 13, 2011 at 11:03 PM, iggy-mac wrote: > Ashish, > > Thanks for your help, that works just fine. > > If I was to take that a step further,

Re: $$Excel-Macros$$ Extract data between two dates

See if this helps you out... Regards, Manoj Kumar On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey wrote: > Hi Kalyan, > > Attached file has been solved per your requirement(s). :) > Let me know if this works. > > Best Regards, > DILIPandey > > On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote: >

Re: $$Excel-Macros$$ Urgent Query

Hi, Please see the attachment, but ur requirement is not clear, u want result when ur value in alternative order or both of the columns has serial order, hope it will meet with ur requirement. Thanks & Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 4:43 PM, NOORAIN ANSARI wr

Re: $$Excel-Macros$$ Re: Formula to add date

thanks again. Very helpful tips! On Jan 12, 10:19 pm, Manoj kumar wrote: > Hello Guys, > > Fill Handle(the small black square on the bottom-right corner of a selected > range of cells) is one of the best option to fill dates, in fact you can > fill Days, Weekdays, Months and Years as well. > > *

$$Excel-Macros$$ Formula of the week - share your best formula

Hi All, >From My Side, Best Formula is Match() Regards, Rajesh. Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Li

$$Excel-Macros$$ How to turn on the auto list for Excel Function?

Hi, I have a very stupid question here. I am using Excel 2003. I don't know why when I am trying to enter a function in the spreadsheet, the remaining part will not show up. For example, when I am trying to enter the function: concatenate. I will write =conca And the remaining part will pop up.

Re: $$Excel-Macros$$ Offset Range Copy

Ashish, Thanks for your help, that works just fine. If I was to take that a step further, how would I amend the code so that the copy range stepped 200 to the right, regardless of how many rows I highlighted ie sometimes I'll copy one row, somestimes it may be 2,3..4 rows. I can do it one at a t

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give b

Re: Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi All, from my side. =INT() On Jan 13, 2011 9:04pm, kiran Kancharla wrote: Hi All, from my side I am adding 2 formulas. 1.Index 2.Match One of the best functions.. Please have a look on the Attachment.. Thanks & Regards, Kiran On Thu, Jan 13, 2011 at

Re: $$Excel-Macros$$ Offset Range Copy

try this Range(ActiveCell, ActiveCell.Offset(0, 200)).Copy On Thu, Jan 13, 2011 at 7:06 PM, iggy-mac wrote: > Hello Group, > > Can anyone help me with this “simple” line of code. I need a line > that will allow me to: > > Starting at the cell I’m in, > Extend right for 200 cells > Activate t

Re: $$Excel-Macros$$ Extract data between two dates

Hi Kalyan, Attached file has been solved per your requirement(s). :) Let me know if this works. Best Regards, DILIPandey On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote: > Dear experts, > > Please help me on my quary. I have date wise depot wise product wise sale > amount. I need to extract s

Re: $$Excel-Macros$$ IF two criteria then count occurrences of "TRUE"

attachement missing On Thu, Jan 13, 2011 at 7:11 PM, mikeb wrote: > I would appreciate some help with the following. I am trying to use > two criteria and if they are true then count the occurrences of the > work “TRUE” in a specified column, I have attached a sample worksheet > using excel for

Re: $$Excel-Macros$$ Extract data between two dates

check the attachment see if it helps On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote: > Dear experts, > > Please help me on my quary. I have date wise depot wise product wise sale > amount. I need to extract sale between two dates matching with other two > criteria(Depot & Product). I have tried

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Dear members, We all come to know about many functions & their best uses. Please keep sharing. Thanks. Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

$$Excel-Macros$$ IF two criteria then count occurrences of "TRUE"

I would appreciate some help with the following. I am trying to use two criteria and if they are true then count the occurrences of the work “TRUE” in a specified column, I have attached a sample worksheet using excel formulas; however I would not object to using VBA to accomplish the task. I act

$$Excel-Macros$$ Extract data between two dates

Dear experts, Please help me on my quary. I have date wise depot wise product wise sale amount. I need to extract sale between two dates matching with other two criteria(Depot & Product). I have tried sumifs & sumproduct formula, but result is not coming properly. Please help Thanks in advance

$$Excel-Macros$$ Offset Range Copy

Hello Group, Can anyone help me with this “simple” line of code. I need a line that will allow me to: Starting at the cell I’m in, Extend right for 200 cells Activate the cells & copy I want to use easy code ie along the lines of ActiveCell.Offset(0,200).Range.Select Or Range.ActiveCell.Offset

Re: $$Excel-Macros$$ Clear Contents based on another cell value

Thanks Ashish Thanks Dave. - Manish On Jan 13, 7:14 am, Dave Bonallack wrote: > Hi Manish, > Place this code in the appropriate VBA sheet window > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) >     If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents     > End Sub > > Ho

Re: $$Excel-Macros$$ Urgent Query

Dear Anubhav, Please see attachement.. Thanks, Noorain Ansari On Thu, Jan 13, 2011 at 1:45 AM, Anubhav Somani wrote: > Dear All, > > I have data for two years arranged in 2 columns respectively. > Example. > > *Yr1* > > *Yr 2* > > A > > A > > B > > B > > C > > C > > D > > D > > > > F > > > >

$$Excel-Macros$$ Urgent Query

Dear All, I have data for two years arranged in 2 columns respectively. Example. *Yr1* *Yr 2* A A B B C C D D F H I Now i want is to make a combined list (lets say in column 3) but there should be no repetitions in this list (as in the above example, after combining, i should o

$$Excel-Macros$$ Link Query

Dear Group, I want to know about how could link more excel sheet in one file without hypper link. Please explain have tools in excel. Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- Some important links for