 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007What is appropriate formula?
Hi, a very inexperienced Excel user needs any help I can get. I have supplier item data for yr 1 and yr 2. Year 2 has some price ammendments and some additional items. What formula can I use to identify any changes in year2 data? Many thanks in advance Kev You need to provide sufficient details if you want some help. How is your data laid out? Do you have separate sheets for year1 and year2? What columns do you use, and what data do you have in them? How many rows of data do you have? What do you want to end up with ultimately? etc. etc. Pete > Hi, > [quoted text clipped - 8 lines] > > Kev Aplogies for being so vague Pete. data in w1 worksheet laid out as below A1 B1 C1 D1 Yr 1 Yr2 Supplier Item / Price Supplier Item / Price Kev > You need to provide sufficient details if you want some help. How is > your data laid out? Do you have separate sheets for year1 and year2? [quoted text clipped - 16 lines] > > > > Kev Hi Kev, Maybe this will help point you in the right direction... http://office.microsoft.com/en-us/excel/HA011039151033.aspx?pid=CL100570551033 Gav. > Hi, > [quoted text clipped - 8 lines] > > Kev Gav, will have a look. thaks kev > Hi Kev, > [quoted text clipped - 16 lines] > > > > Kev |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.