All Questions
Tagged with microsoft-excel worksheet-function
7,324
questions
1
vote
2
answers
8k
views
EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)
I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel?
E.g.
Date-----...
71
votes
4
answers
162k
views
Is it possible to sum an entire column without setting explicit cell boundaries in Excel?
I'd like to sum all the values in a column starting from a certain minimum value, but I don't want to give an upper bound because any value in the table will be appropriate for summing (minus the ...
0
votes
2
answers
7k
views
Specify formatting information in Excel forumla
Is there a way to specify the formatting in an excel formula?
=IF(A1="Large","This is BIG","This is small")
Where "BIG" is of a font size larger than the text for "small"?
(I'm aware of conditional ...
3
votes
2
answers
33k
views
Use cell formatting (e.g. "Good", "Bad", "Neutral") in formulas?
I am compiling a comparison of different pieces of software in an Excel spreadsheet. It is a big long list of features (the rows), with each column being one of the applications I'm evaluating. I've ...
11
votes
7
answers
34k
views
Using excel, how can I count the number of cells in a column containing the text "true" or "false"?
I have a spreadsheet that has a column of cells where each cell contains a single word. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the ...
1
vote
2
answers
180
views
I hyperlinked a cell in excel 2003, formula issues?
I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...
0
votes
1
answer
497
views
MS Excel convert cell matrix (1x15 -> 3x5)
What is the formula for displaying cells in a 3 cell increment at a time, like A1, A4, A7, A10?
Moreover, would it be possible to transform below a list (1x15) of data into a table(3x5). Thanks.
PS....
1
vote
2
answers
9k
views
Excel cell references not updating when referenced cells are sorted
There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price ...
3
votes
1
answer
23k
views
How to fill cell reference down column without changing cell reference
I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the ...
0
votes
2
answers
334
views
Excel Matching problem with logic expression
I have a block of data that represents the steps in a process and the possible errors:
ProcessStep Status
FeesPaid OK
FormRecvd OK
RoleAssigned OK
CheckedIn Not Checked In.
...
0
votes
2
answers
1k
views
Spreadsheet formula: lowest 100 values in a range
Is there any way I could sum up the lowest 100 values within a range?
I know that min() would give you the lowest value but i need something to return the 100 lowest values.
I just used 100 ...
1
vote
1
answer
3k
views
Excel: Summing values within a certain date range (> start date and < Finish date)
How do I include a 'Between these dates' criteria inside a SUMPRODUCT?
=Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost))
What's the way to manage dates (between)...
0
votes
1
answer
1k
views
Pivot tables: How can I total the subtotal?
My SUBTOTAL row shows Person A needs £115, Person D £234 and Person G £789, but how do I SUM those totals and get it to show the total on the same ROW?
The Rows are subscription names.
The Value ...
3
votes
2
answers
10k
views
How can I change a cell's background color based on the cell's current value?
I have a column with function values of True or False:
=IF(ISNA(A1), false, true)
from row 1 to 5000+ rows. I would like to mark all the False as red background color or text as red. Is there any ...
2
votes
1
answer
590
views
Excel: ROUND & MOD giving me strange DATE results
This is sort of related to a previous question. My formula, which seemed to work fine yesterday now gives strange results.
Today is the 30th of March (30/03/10). It's 10:11am on the clock that the ...