All Questions
Tagged with microsoft-excel worksheet-function
7,327
questions
-3
votes
1
answer
551
views
Excel: How to have a cell change color when it has the same value as another cell?
I have used conditional formatting to change a row's color for specific values of another cell before but now I want it to change color when the value of a cell is equal to the one next which all have ...
-3
votes
1
answer
67
views
Finding the year in another table in Excel when the value isn't the same
I have two tables. I would like to get the data from Blue to the Orange table with following steps:
The first column of Orange table has both positive and negative values as percentage, and I need to ...
-3
votes
1
answer
66
views
Excel: Count if values match
I basically have two predetermined worksheets with data in a format I can't modify the way it populates.
On one sheet "SSP" I want to check row I against row E on a different sheet "YMS" to check for ...
-3
votes
1
answer
151
views
Excel - IF formula for multiple cells
I have 5 cells with either 1, 0 and -1 values.
I want to build a formula that allows me to have, for example, a 0 or a -1 if any of those 5 cells are a 0 or a -1.
Can you please help? Thanks.
-3
votes
3
answers
17k
views
How do I get Excel to look up customer names from another sheet?
I have two sheets in Excel i.e. sheet1 and sheet2.
In sheet1's column A there are account numbers of the customer and in column B there are names of the customers.
Now I want that in column A of ...
-3
votes
2
answers
174
views
AVERAGE function not working
I Have two columns containing dates.
I used this formula to find how many days there were in between the dates:
=DATEDIF(J7,K7,"md") &""
This produces the number of days without putting the ...
-4
votes
4
answers
6k
views
Need a formula for Leap Year
I need a formula in which, if the date is equal to or greater than 03/01/2015 and less than or equal to 02/29/2016 then I get the result as "Leap Year" or "No Leap Year".
Thanks!
Sumeet
-4
votes
1
answer
10k
views
Auto fill date that increments after every 4 rows
I have data as shown below. All the data has the same date in the BILLDATE column (e.g., 01/04/2015; that's dd/mm/yyyy). I want to adjust the dates on these 70 records in a particular month so that ...
-4
votes
1
answer
94
views
Why am I getting a #Value error with my IF statement?
I keep getting an #VALUE error with my IF statement in Excel. Any ideas why? Any help is greatly appreciated!
=IF(
OR(
R2 > 3
),
0,
( IF(
R2 = 1,
...
-4
votes
1
answer
1k
views
I need a formula that looks for the first two numbers in a cell and add 0 in front of it [closed]
hey,
Im looking for a formula that looks for the first two numbers in a cell, and if it starts with 13 or 14 and its length is 9 digits, it adds 0 in front of the number. i hope its possible.
for ...
-4
votes
1
answer
2k
views
Consolidate Text Data in Excel
I have an Excel document containing exam results. The results are in one column and appear as Pass or Fail.
I want to know percent of candidates who passed.
-4
votes
2
answers
89
views
amount calculation in excel
I have a payment amount of 2628.46. This payment should be used to pay off, in turn, three components listed in columns BZ, CA and CB. So, first I subtract the April Principal from the May payment. If ...
-4
votes
1
answer
84
views
How to sum in Excel with month logic?
Mentione in the picture, I have 2 Excel sheets, Sheet 1 with ID Q1 and Z1, and NAME in column and month in rows. And in Sheet 2, I have ID Q1 and Z1 with the amount in month column.
My requirement ...
-4
votes
1
answer
167
views
Based on input value, place an associated object in another cell
I have a collection of predefined input codes. When an input code is entered in an input cell, I want to automatically post an associated object in an output cell. For example, using the code table ...
-4
votes
1
answer
104
views
I need some help in excel validation [closed]
I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation.
1) A column that accepts only letters, no numbers or ...