I need your help again (FDibbins???).
You last provided a formula for me that went like: =IF(A2-A1=1,"",IF(A2-A1=2,A2-1,MAX(A$1:A1)+1&"-"&A2-1)).
This formula used on my spreadsheet helped me to come up with a list of numbers that were not within column number 1 (A). I need to do this again but the formula is not working.
Do you need more information?
My DBA here noticed absolute values in the spreadsheet that he'd provided to me so I think the formula does work afterall still. I am sorry for the confusion.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks