Search results

Yes, I downloaded. Am looking at the file now. I made a dynamic named range for column A, TargetNo =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1) Then in C2, I put this formula and copied down: =IF(ISNA(MATCH($B2,TargetNo,FALSE)),"incoming",B2) This might get you started. ________...

For some reason, when I click on the link to downlaod, I get a message stating that it is an invalid attachment link. ________ Ford Prodigy Specifications

Howdy. Regarding the first, can you post a simple example? Re: second question, you can use the concatenate symbol (&), if you want dashes =A2&"-"&B2&"-"&C2 if no dashes needed, then =A2&B2&C2 ________ PLYMOUTH SUPERBIRD

Howdy. Can you post a simple example? ________ KAWASAKI VN1500T

Howdy. If I understand correctly, you could use COUNTIF =COUNTIF(Sheet2!$A$2:$A$100,"X") Adjust as needed If it requires two or more conditions, use SUMPRODUCT. ________ TOYOTA 1/X HISTORY

My dream job (totally unexpected but a 30 year dream) recently became a reality, nothing in anlysis or Excel or... I am now President of our Seminary. My primary responsibilities in the first two years will be developing/providing continuing education for those who are already pastors - with a...

Another option might be to use dependent lists with an INDIRECT function in Data > Validation. ________ Toyota tf109

As for the text wrap, you could define the range (MyRng) and then use it as follows: With MyRng .WrapText = True End With While it doesn't seem to make sense using the With clause, it allows more flexibility if you need to set up other aspects of alignment as well. Regarding the first...

Howdy. There probably is enough differences in the functions for this kind of thing, that it might be better to look directly in Access, not Excel. But that is only opinion. :) ________ Honda civic (sixth generation)

Howdy. Can you post a sample, with the solution filled in that you would expect (maybe two worksheets, with two different samples). ________ Vapormatic Vaporizer

If you ever feel up to it, you might consider using VBA for Pivot Tables, and then continuing on with VBA using that data. Very fast, flexible, and uses power of Pivots with much greater options. Check out chapter 12 of VBA and Macros for MS Excel by Bill Jelen and Tracy Syrstad. That chapter...

Howdy. Check out PasteSpecial Values ________ RA106

Howdy and welcome to the board. Can you post a sample of the workbook? ________ ARIZONA MEDICAL MARIJUANA DISPENSARIES

Howdy. Depends how you have defined the named ranges: CYOrigin, row1, and list. (Also, as a habit I would use FALSE rather than 0 and TRUE rather than 1 in the formulas; but that is just me.) BTW, it is best not to use normal Excel names (List) for your defined names. Make it MyList or...

Howdy. Don't necessarily have a ready made solution. But networking with Excel can be done, but it will be harder to maintain and will require stricter guidelines on use. Access is the better route to go. Also, for clarification, there are three different locations, and a total of seven...

Howdy. you can do that by using the SUBTOTAL Function, that way you can avoid VBA. But if you want, it can be done. ________ FREE JOOMLA THEMES

Just a note, instr does not exist in Excel. :) MID, RIGHT, and LEFT will be your options. If you need specific help with those, let me know. ________ Vapor Genie

Also posted here ________ GENETICALLY MODIFIED FOOD

I have been out of town on work, so haven't looked at it. I will download and take a look today. ________ Suzuki Rm85

Howdy. From reading your last post, it seems that you are trying to use the Data tab as a display. Am I understanding that correctly? If so, it seems to be the wrong way to approach. This is why in your data layout, having another ID number doesn't really seem help. Does ProductID uniquely...