LinkBack URL
About LinkBacks
See if the attached does what you want. I punted and used a UDF.
See if the attached does what you want. I punted and used a UDF.
Entia non sunt multiplicanda sine necessitate
I tried the formulas and everything came up #NAME?. Do I change something in the formula?
You have to enable macros when prompted. See http://grok.lsu.edu/Article.aspx?articleId=6144
OMG!!! It worked!!! God bless you fellow Texan!!
Ok I enabled macros. Should I just be able to add to it now?
And I don't know what punt or UDT mean either. I enabled macros and tried to duplicate ur formulas but it still wouldn't work.
A UDF is a user-defined function. This UDF is one I wrote and put in the workbook I posted.
Why don't you just add your data to that workbook?
Then copy the formulas down, one whole row at a time. The formula in each row is a single array formula; see http://office.microsoft.com/en-us/ex...001087290.aspx
Last edited by shg; 05-16-2011 at 09:21 PM.
Oh ok. Sorry, I was doing it comletely wrong. Thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks