I looked up DGET in the Excel help and am a little lost. The range of my datapool is huge (A2:G500) and instead of enter the info by hand into the adjoining spreadsheet I want it to search for the number that goes is each cell and populate that cell. example:
Route Loc Type Initial...
PHV - where is the formulas forum? I would like to see if there is an answer to this question and cannot find said forum in the list of forums. Any ideas?
I'm using Excel Visual Basis 6.3 and am NOT a programmer however I have some advanced skills in Excel. What I have is a 2 worksheet file (I can put it on one if it works better). One sheet contains exported information from a database and contains 6 different columns. In each cell of the...
I'm using Excel Visual Basis 6.3 and am NOT a programmer. What I have is a 2 worksheet file (I can put it on one if it works better). One sheet contains exported information from a database and contains 6 different columns. In each cell of the second worksheet I need to do the following:
In...
Have you tried a look up table? Essentially what a look up table does is say "match this record with the product ID on the vendors worksheet and return to me the value in colum X (price value)". Search the function list for Vlookup (vertical lookup) and it should walk you through it.
First I would like to thank all of you selfless people who help others such as myself who are struggling with programming/software issues. My company is either too cheap or network problems have prevented them from installing help for Crystal reports on my computer so I come here often to...
We have an imported document that we will be bringing into Excel which has 3000+ lines of data. We want to insert a blank line after each line of data and would like to use a formula to do it instead of manually inserting lines. If we have to we can record a macro the first time we do this but...
Am new to Crystal and working with 8.5. I have used the Wizard to create a cross tab report. I have 3 summary columns at the bottom of my cross tab - 1 sums the data, 1 counts the data and the last shows the average. I have included all of them in my Summary section. Two of the three...
I'm kind of a novice at Excel and not sure if I understand the question correctly - but if you press Ctr+~ (tilda key) you will see the contents of each cell including calculations and linked cells.
I taught my Mom how to use the computer and specifically Excel this last weekend. She is paranoid by the thought of identity theft. (I think it's a real threat but she doen't have internet service so I'm not sure how real the threat is to her computer.) She had me add a password for herself and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.