Re: $$Excel-Macros$$ Need to remove Alt + Enter

Yes and it the cell is longer than the words in the first line, the second line appears on the first line. From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Fri, August 13, 2010 9:05:20 PM

Re: $$Excel-Macros$$ Conditional Formatting on a formula

Thanks but this still isn't working if the formula result for a cell is blank. From: Rajender Soni soni.rajen...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, August 12, 2010 8:51:03 PM Subject: $$Excel-Macros$$ Conditional Formatting on a formula Hi

Re: $$Excel-Macros$$ Need to remove Alt + Enter

Thanks Dave.  This still shows the info as all one line/sentence.  I still need the info to show as 3 lines/sentences in one cell.  :( Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent:

Re: $$Excel-Macros$$ Need to remove Alt + Enter

Dave, Is there a way to do this but have it only happen if there's nothing after the Alt Enter?  For example, if there were 4 rows but the last one didn't have anything in it, only the last one would be gone?  Example below: Entered Test Test2 Test3 Formula Result Test Test2 Test3

Re: $$Excel-Macros$$ Need max date

the data area to date format.  Then Hide the grand total. Srinivasan Ethirajalu   On 8/5/10, Nadine S n8dine4ma...@yahoo.com wrote: Sheet 1 contains # Date 1001 03/01/10 5252 02/15/10 1001 02/15/10 1001 02/15/10 1001 08/02/10 5252 03/15/10 5252 01/06/10 2355 04/12/10 1001 06/10/10 1001 03/14

Re: $$Excel-Macros$$ Need max date

that. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Sat, August 7, 2010 8:24:16 AM Subject: Re: $$Excel-Macros$$ Need max date I'm getting the result #VALUE!.  Could that be because what in column A in both sheets is alpha numeric

$$Excel-Macros$$ Need to remove Alt + Enter

I often receive a file that has extra Alt+Enter in it which makes the cells long and therefore the files long.  Is there anyway I can remove these?  The # rows is 700+ - it can vary. Thanks. -- -- Some

Re: $$Excel-Macros$$ Need max date

, format the data area to date format.  Then Hide the grand total. Srinivasan Ethirajalu   On 8/5/10, Nadine S n8dine4ma...@yahoo.com wrote: Sheet 1 contains # Date 1001 03/01/10 5252 02/15/10 1001 02/15/10 1001 02/15/10 1001 08/02/10 5252 03/15/10 5252 01/06/10 2355 04/12/10 1001 06/10/10

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

Hi Dave, Thanks for responding.  No, I haven't gotten an answer so thank you, thank you, thank you for helping me. Sheet 1 contains the details and Sheet 2 is the summary.  So, Sheet 1 B, C, D has information that may show the same on multiple lines due to different information in the others

Re: $$Excel-Macros$$ Re: Need to sum if data is in another cell

(10),0),IF(Sheet1!ZS(16)0,Sheet1! ZS(15),0),IF(Sheet1!ZS(21)0,Sheet1!ZS(20),0)) Nadine S wrote: [snip] Unfortunately when I put Stuart's formula into cell C2 on sheet 2, I get #NAME? as the result and not $1950. I'm sorry, I did not properly translate everything from my German Excel

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

, Nadine S n8dine4ma...@yahoo.com wrote: Let me try this again. Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, and H.  If those all match then I need to check if column AH in Sheet 1 matches either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet

$$Excel-Macros$$ Need max date

Sheet 1 contains # Date 1001 03/01/10 5252 02/15/10 1001 02/15/10 1001 02/15/10 1001 08/02/10 5252 03/15/10 5252 01/06/10 2355 04/12/10 1001 06/10/10 1001 03/14/10 2355 01/06/10 Sheet 2 contains # Last Date 1001 8/2/2010 5252 3/15/2010 2355 4/12/2010 The dates in sheet 2 in

Re: $$Excel-Macros$$ Re: Need to sum if data is in another cell

and not $1950. Thanks all. From: Stuart Redmann dertop...@web.de To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, August 4, 2010 6:35:31 AM Subject: $$Excel-Macros$$ Re: Need to sum if data is in another cell Nadine S wrote: I have a worosheet

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

Let me try this again. Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, and H.  If those all match then I need to check if column AH in Sheet 1 matches either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 1.  The result needs to show on

$$Excel-Macros$$ Need to sum if data is in another cell

I have a worosheet with cokumns for 20+ payments.  These columns track the date it was entered for payment, amount, check date, record number for each of the 20+ columns.  In another sheet, I want to sum the amount entered and the amount paid by line.  Meaning, row 2 on sheet 1 ties to row

Re: $$Excel-Macros$$

Dave, Thank you so much.  This works!  You don't know how thankful I am.  I needed that peice before I could move forward with a workbook.  Thank you!!! Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com

$$Excel-Macros$$ Sumproduct with 3 criteria +

I have a workbook that needs a sumproduct. I have: =SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000)) What I need is a total of the result of that plus

$$Excel-Macros$$

I have information in the first three cells of a worksheet and in the forth is a Yes or No. In worksheet 2 the first three columns contain the same type of information as in sheet1 but sheet 1 can list that information multiple times whereas sheet 2 only lists that unique combination once.

$$Excel-Macros$$ Need specific info on unique combination

Resending with a subject.  Sorry. I have information in the first three cells of a worksheet and in the forth is a Yes or No. In worksheet 2 the first three columns contain the same type of information as in sheet1 but sheet 1 can list that information

Re: $$Excel-Macros$$ Re: Find duplicate with 3 criteria in Excel 2003

there are no #NA values. Great things can be done with available (inbuilt) functions and commands in excel, provided we know how to use them. Regards, Kishan Reddy, K On Jul 31, 1:17 am, Nadine S n8dine4ma...@yahoo.com wrote: Is there a way to find a duplicate with 3 criteria?  I know it can

$$Excel-Macros$$ Find duplicate with 3 criteria in Excel 2003

Is there a way to find a duplicate with 3 criteria?  I know it can be done with one.  Assuming there is data in columns A, B, C.  I need to find if there are any duplicates that match all three in those columns.  Thanks.  --

Re: $$Excel-Macros$$ Index match with 3 criteria

.  Thanks again. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Thu, July 29, 2010 7:28:24 AM Subject: Re: $$Excel-Macros$$ Index match with 3 criteria This worked originally but for some reason isn't working now.  I've included

Re: $$Excel-Macros$$ Index match with 3 criteria

Thank you so much.  I just couldn't see it.  I hate when that happens. From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thu, July 29, 2010 4:38:54 PM Subject: RE: $$Excel-Macros$$ Index match

Re: $$Excel-Macros$$ Need list style from data

in Data sheet. Thanks Regards Sandeep On Sun, Jul 25, 2010 at 7:39 PM, Nadine S n8dine4ma...@yahoo.com wrote: When I run either macro I don't see anything different.  So I can't tell if it's working.  Also, how do I put this macro into my original file?  I just sent a sample.  Thanks

Re: $$Excel-Macros$$ Need list style from data

for your list. Note: These macro deletes everything from cells A2:E65536 and then put the list. You can extend Items and Rows in Data sheet. Thanks Regards Sandeep On Sun, Jul 25, 2010 at 7:39 PM, Nadine S n8dine4ma...@yahoo.com wrote: When I run either macro I don't see anything different.  So I

$$Excel-Macros$$ Need list style from data

Hi all, I have attached a spreadsheet that shows list data to the left but then under the Item numbers is the amount of reach combo in the list and item number.  I would like the data in list format instead of pivot table style format.  The result I'd like to see is included in the worksbook

$$Excel-Macros$$ Need SUMIF with 3 criteria

I need to sum a column if three other columns in one sheet match the three in another.  Can this be done?  Thanks. Nadine -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Index match with 3 criteria

Thank you.  This worked!  WooHoo!  From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a

Re: $$Excel-Macros$$ Re: Index match with 3 criteria

You can use the below formulae: =IF(AND(A1=Sheet1!A1,B1=Sheet1!B1,C1=Sheet1!C1),Sheet1!D1,not) Regards Rajender Soni On Jul 15, 1:39 am, Nadine S n8dine4ma...@yahoo.com wrote: I need to lookup a value based on matching 3 other columns.  I do not want to use a concatenation and then look up

$$Excel-Macros$$ Count months

If a cell says Apr - Jun what formula is there to count how many months that is?  The month range is in one cell and the formula would be in another.  Thanks. Nadine -- -- Some important links for excel

$$Excel-Macros$$ Index match with 3 criteria

I need to lookup a value based on matching 3 other columns.  I do not want to use a concatenation and then look up that. I have Sheet1 that has 4 columns in it and Sheet2 that has 3.  In Sheet 2, Column D, I need a formula that will return the text in Col D on Sheet1 if the values in the first

Re: $$Excel-Macros$$ Increase the Text Size in drop-down

Dave, Can you expand on this option to use a combo box?  I'd be interested in learning more about it.  Thanks. Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wed, July 7, 2010

Re: $$Excel-Macros$$ Need index match

...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, July 4, 2010 6:25:26 AM Subject: Re: $$Excel-Macros$$ Need index match Nadine, Just type into Sheet1 Cell AQ2 the following: =VLOOKUP(TEXT(D2;@);Sheet2!$D:$O;12;0) regards 2010/7/2 Nadine S n8dine4ma...@yahoo.com Attached is a workbook

Re: $$Excel-Macros$$ Need index match

I made some changes thanks to your suggestion in your vlookup formula.  I got it to work with the index,match.  Thank you!! From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Mon, July 5, 2010 10:01:20 AM Subject: Re: $$Excel

$$Excel-Macros$$ Protecting cells

Is there a way to make sure the data in certain cells cannot be changed without Protecting the worksheet?  We have data that is received from our customer that I would like to ensure stays intact.  Certain portions of the worksheet/workbook that the data is stored in needs to be modified by

Re: $$Excel-Macros$$ Re: Trim first 8 characters off a cell

at 12:43 PM, Nadine S n8dine4ma...@yahoo.com wrote: Haven't seen this come through yet so I'm sending this again. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Mon, June 28, 2010 9:55:14 AM Subject: Trim first 8 characters off

$$Excel-Macros$$ SumIF Sumproduct

I'm resending since I haven't gotten a response.  I'm hoping that it's because it may have gotten lost in the shuffle instead of there being no formula for what I want to do.  :)  Thanks. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com

$$Excel-Macros$$ Testing

I'm sending this to see if it goes through.  I've sent two messages already today asking for help and neither have come through.  Sorry for the extra mail. Nadine -- -- Some important links for excel users:

$$Excel-Macros$$ Trim first 8 characters off a cell

I have a cell that I'd like to write a formula that returns all but the first 8 characters.  The cell's data can be any length.  Thanks. Nadine -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Re: Trim first 8 characters off a cell

Haven't seen this come through yet so I'm sending this again. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Mon, June 28, 2010 9:55:14 AM Subject: Trim first 8 characters off a cell I have a cell that I'd like to write

Re: $$Excel-Macros$$ Index match multiple

? Regards, Andy On Sat, Jun 26, 2010 at 4:34 AM, Nadine S n8dine4ma...@yahoo.com wrote: I have two worksheets:  Sheet 1 contains extracted data from an application Sheet 2 is my working file I need to match 3 different columns in sheet 2 to those columns containing the same data in Sheet 1 and I

$$Excel-Macros$$ Index match multiple

I have two worksheets:  Sheet 1 contains extracted data from an application Sheet 2 is my working file I need to match 3 different columns in sheet 2 to those columns containing the same data in Sheet 1 and I need the formula to return the corresponding  value in another column in sheet 1.