Instead of writing the formula to add two cells as say, B4+B38 in Excel, I
want to build the formula using the contents on another cell, e.g.
I've tried B4+"B"&(TEXT(B13,0)).
The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That

I have a sheet that by selecting a scenario from a drop down list some of the
values change.  This normally works fine.  But this time I have a slight
problem.
In scenario 1 cell B4 will equal 500 but if scenario 2 is selected than B4

I have 3 dates, a date that the patient attended the hospital and a range of
dates. I need a formula that tells me whether the date the patient attended
the hospital falls between the range. How do I best go about doing this?
Thanks

I'm trying to get a list of balances for different account numbers for
different currencies. Some accounts have different currencies however and so
they need to satisfy the conditions of being both a certain currency and a
certain account number. This is the latest I've got so ...

This is chicken feed compared to the complex issues I've read on this site,
but your help would be greatly appreciated.  My spreadsheet has 451 sites
listed in a column A.  Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to ...

Purchase new computer with Vista,
Vista nixes installation of my old Lotus 1-2-3 program (registry
upset),
Purchase Excel 2007,

I am trying to set up an attendance sheet in Excel that will keep a total of
the days missed but subtract the days missed after a rolling year.
I am using column A for the date, column B for the number of days missed
(typically just a 1 or .5 for each particular date) and column C ...

I would like to pull back all the columns that match the lookup_value by
copying and pasting the VLOOKUP formula, but the column_index_num stays
the same.  Instead of changing the column_index_num manually in each
cell is there a formula or value that will increase it by 1 when I ...

how do  i set a transparent background sceen behind an excel spreadsheet ?

how do i automatically transfer data entered in one spreadsheet to another
spreadsheet with the same workbook

I am designing a sales pipeline which is easier and faster to complete. I am
utilising checkbox controls and this is working ok. My question is: Am I able
to have the contents of a cell copied into another cell on a new sheet
(within the same workbook) when a tick box is ...

I have a list of 135 text entries, some of which duplicate.  My goal
is to find the most often used entry.  For example:  Lets say I have a
list:
Apple, Apple, Apple, Orange, Orange, Grape

There is simple formula =sum(A1:A10. If any of cell in range A1:A10 is
changed, how to make the cell which contain the formula display the change?
Clara

Win2K Prof
Excel 2k3 SP2
I have a table that looks like this with over 55,000 rows:
Dist Nbr    Customer Acct Nbr    Customer Number    Bill-to Company Name    Bill Grp

I have a spreadsheet which will be completed by various users.  I want the
spreadsheet to open up to a specific sheet (already got that) and only show
the Menu Bar.  I want the user to be able to open another spreadsheet, not
this one and have their toolbars as they always do.