Hi mandeep. I have to compare prices of different varieties in various markets across markets. Mostly the price comparison is on daily/weekly/Monthly/Yearly basis and thier absolute change or diffrence between two dates.
But in the above formula mentioned by you,i have to select dates for various reports and to compare the different dates but in this i have to change the formula daily. And also to keep out the market or variety whom price are not available for the two dates. Is there any permanent way ,any coding or any other way. On Tuesday, November 18, 2014 10:41:27 AM UTC+5:30, Mandeep Baluja wrote: > > Create a calculated field and set the format of text according find the > result attachment. > > Thanks > *Mandeep baluja <http://vbaexcelsql.blogspot.in/>* > > On Monday, November 17, 2014 2:11:34 PM UTC+5:30, ram gopal yadav wrote: >> >> Dear all, i need your help in attached excel. >> >> In Worksheet named 'Master' - Daily prices are hand filled from various >> weblinks and sources. >> >> In 2nd worksheet named 'pivot'- i get table from "master sheet" for >> variety prices in different markets. >> >> Here the blanks remain blank >> >> In 3 rd worksheet named daily- >> It is the output report to be paste in word file. >> Here i have to find changes >> and also delete the markets or variety whom last two day prices arenot >> available. >> >> >> Problem are >> >> I have to do daily removal of markets whom both day price are not >> available >> >> second,if a single day price is available change came as huge by >> considering blank as zero , >> >> so i have to do manually the >> Daily removal of markets whom both day prices are not available and also >> write NA (not available) in the price column whom one day price is >> available. >> >> Is it, any way where i can calculate the change in pivot itself and hide >> the blank automatically. >> >> >> Please find the enclosed template file >> >> Looking forward for your response asap. >> >> >> >> Regards. >> >> RAM GOPAL YADAV >> Contact-08130155401 >> >> >> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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. For more options, visit https://groups.google.com/d/optout.
