in excel, I need to add columns with names in the cells.  to come up the the number of cells.  do you know the formula?  help.
136163
Use the good formula CountIF.\n\nOr\n\nYou can use also SumIf.\n\ne-mail me
328661
Its been awhile since i've mucked around with crystal but isn't there a table object that you can put into the report to display 10 rows and 6 cols? you can then just populate this table object with data from your database
284654
In Cell C1, insert "=A1 & " " & B1", assuming first name is in A and last name is in B.\n\nDrag the fill handle of C1 to fill up the other cells.\n\nCopy the Column C and right click. Select "Paste Special", select "Values" only. Now you can delete Columns A and B if you want to.
503292
If you have hidden the row by setting the height to zero, which is also what excel does when you pick "format", "row","hide", then you will first have to have a way to determine the row height of each row in the range. There is not a function to do this in excel (although there is one to determine width), but here is a link to a page that can tell you how to create one\n\nhttp://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/65d8576809d44e8d/a502f72888df4806%23a502f72888df4806\n\nAfter you've done that, you could probably use a =DCOUNTA(range,column offset,criteria) function.  \nFor your criteria value you would have to use something like =AND(RowHeight()>0,ISNUMBER())\n\nYou would have to play around with the syntax and exact functions depending on whether you are counting numbers or text, and remember you need to build the rowheight function before putting it in the formula.\nI find it is best to build a complex formula from the inside out. For instance, start with just the isnumber formula and make sure it returns a valid result. then try the rowheight formula you've built and make sure it returns a valid row height on just a current cell, before you us it as a criteria. then put them together within the logical =AND function.\nyou might want to play with working with common functions within an =and before trying the =rowheight function.
334837
In spread sheet 1 I created the following\nSorry but the formatting is not to good.\nColumn A\n1\n2\n3\n\nColumn B\nhello\nhi\nhowdie\n\nIn spreadsheet 2 I created this\nColumn A\n1\n2\n3\n\nColumn B\n=LOOKUP(A1,Sheet1!A1:B3)\n=LOOKUP(A2,Sheet1!A1:B3)\n=LOOKUP(A3,Sheet1!A1:B3)
76343
GETPIVOTDATA does get in the way...\n\nEither type the cell reference directly, or select another cell outside the table then click and drag it into the pivot table to the cell you want to refer to.  No other way round it I'm afraid!
292977
I didn't get you well,\nExcel already can open csv files (Comma separated values) if ther were seperated with commas.\nWhy you need to convert it to columns?\nany way...\n\nsend me more info.\n\n\nXLMan
446109
To make the PIN number show up as a wildcard string:\n\nSelect the desired cells (Column A) right click and select "Format Cells", Select the "Number" tab, and go to "Custom".\n\nIn the cell that now says "General" type:\n"****";;;@\nexactly as shown\n\nAs for the other part, I think your best idea is to use an additional column and use the LOOKUP function.  Don't forget that you can always hide the extra columns by right clicking and selecting "Hide"\n\nHope this helps!\n\nPS  If none of this works, or if you have additional questions, email me at ThuckingSplut@yahoo.com, RE: Yahoo Answers - Excel.  I'll do my best to help you out!
543124
I thought I was pretty handy with excel, but I have no idea what you're asking! Do you mean the options pop-up you get if you right-click on a cell? Or Insert > Function? (on the pull-down menu, or click on the 'fx' button just below your toolbar/s). Perhaps if you clarify your question you might get a more helpful answer than I feel I can give you.
145099
Use the Median function.  Go to the cell you want the answer to appear in and type\n\n=median(xxxxx)\n\nwhere xxxxx is the location of the cells with the numbers that you described.  For example, if your numbers are in cells A1 through A7, your formula would look like\n\n=median(A1:A7)\n\nIf your numbers are in nonadjacent cells, you can separate them with a comma, like\n\n=median(A1:A4, A6:A8)\n=median(A1, B1:B5, C2)\netc.\n\nYou don't have to type the numbers (i.e. 10, 10, 20, 30, 30, 30, 30) in the formula - just use a reference (i.e. A1:A7) so that if you change any of the numbers, your median will automatically recalculate.
389252
The easiest way if you use the default sheet names Sheet1, Sheet2 .... Sheet30 \n\n=SUM(Sheet1:Sheet30!A1) \n\nIf you use custom sheet names: \n\nInsert a new sheet before the first sheet and name it START. Insert another new sheet after the last sheet and name it END. \n\n=SUM(Start:End!A1) \n\nIf you will need to create any new sheets that should also be used in this calculation just insert them between START and END.
3949
Insert the value "-1" into a cell.  Copy it.  Highlight all the cells you want to change.  Right Click>Paste Special>Multiply.  This will multiply all cells by -1.\n\nYou can always just hide the row/column and create a viewable row/column that is that (-cell).
460568
Click on one of the fields you want to display this way.  Then go to Format, Cells, Custom.  In the Type field put 000'000'000'000.  Hit enter.  It will display the way you want.  I just did it, so I know it works.\n-MM
375925
I'm not sure what kind of formatting you want to do, but In my experience the conditional formatting is set based on the result (value) of the formula, not the cell formula syntax (as it would if you set the cell format to be text, thus displaying the formula syntax instead of the result.  If you like, click my screenname and send me a message with more details and I will try to help.
379558
Why not use four columns for each date with the time of each admission or discharge in the cells?\n\nDay Admission.... Day Discharge.... Night Admission.... Night Discharge\n8:00 am.... 8:30 am.... 6:00 pm.... 7:00 pm\n8:15 am.... 10:00 am.... 6:15 pm.... 9:00 pm\n9:15 am.... 11:00 am.... 11:15 pm.... 10:00 pm\nblank.... 12:00 pm.... blank.... 10:15 pm\nblank.... blank.... blank.... 10:45 pm\n\n\nThis way you could have some other cells use the count function to calculate that in the above example there were three day admissions, four day discharges, 3 night admissions, and 5 night discharges.
482222
ok. set up 2 columns\ncolumn 2 has x values spanning -7 to +7(type -7, -6, -5 in the first 3 boxes, then select the 3 boxes and click on the bottom right corner of the "3" box and drag the numbers down to 15 spaces. excel will enter the rest of the numbers for you until you have a range from -7 to +7)\n\nin column 1 you set up ur equations. type this: =(click on the 1box in the 2nd column, excel will insert a alphanumeric designation for this number)*(8-2*(click on the 1box))*(6-2*(click on the 1box))\n\nthen select the box with the formula u just made. and right click the bottom right corner and pull it down 15 spaces. so that for every x value you have, excel gives you a V value.\n\nThen select Insert, Chart; select X,Y scatter\nclick on the top tab that says series\nthen add series\nclick on the icon beside x values, then highlight your 2nd column (all 15 values)\nthen click on the icon beside y values and select the 1st column (all 15 values)\n\nThat should do it.\njust repeat that for all your different equations and you should be fine! GL
21573
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.