We are getting different values in column D and E because the formula used in column D has relative cell reference because of which references are changing but in case of column E cells are fixed. Result of which when we are moving to D24, in case of column D references are $D$23 but it column E it is $D$22. If you can provide relative references in column E it should solve our problem. To do so you can take the formula of column D and use it in column E just remember to subtract one from column Ex. ADDRESS(ROW()-1,COLUMN()-1.
On Friday, January 25, 2013 6:35:57 PM UTC+5:30, Sadia Khalid wrote: > > > NO > > its not doing this > > see this file > > > https://skydrive.live.com/redir?resid=DD0BC148DF66DAC4!176&authkey=!ANSe4WnuJ1fhJHo > > I want to get the values like in column E in colored cells , the formulas > in both the columns are same except the relative cell referencing. > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
