All Questions
205
questions with no upvoted or accepted answers
3
votes
3
answers
170
views
Excel data in rows and columns to be reformatted
I have data in Excel in a staggered format. There is a customer ID in the left-most column and the details of that customer are in different rows within different columns. I need to rearrange the ...
2
votes
2
answers
254
views
Stuck in the excel formula for duplicate removal
=IF(COUNTIF('PRDA Data'!S$2:'PRDA Data'!S2,'PRDA Data'!S2)=1,'PRDA Data'!S2,"")
This formula is used to eliminate the duplicate from another sheet. Now the issue is Duplicates are removed from the ...
2
votes
1
answer
146
views
Multi-conditional count with complex conditions
I have 4 columns and many rows. I need a formula for counting how many rows meet the following criteria:
contains a certain text in column A
contains a certain text in column B
contains a value of 0 ...
2
votes
1
answer
97
views
Conditional formatting with several conditions depending on different cells
I currently have a table in excel that looks like
.
The table shows four projects, each with three stages with each having an expected and actual start date for that stage.
I want to create a ...
2
votes
1
answer
798
views
Excel replace multiple text options within one cell with other text
How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function?
For example:
My report output ...
2
votes
2
answers
280
views
Drop Down List and one formula
I am trying to get an average depending on two drop down lists.
But i would like to get an average even when the second drop down has no input in it.
The formula I use is a simple: AVERAGEIFS with: ...
2
votes
2
answers
10k
views
VBA: How to replace entire Excel cell value basing on its content?
I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
2
votes
2
answers
314
views
Problems figuring out weekly scheduling and hours past midnight
This is a screenshot of what I have
What I'm trying to do is have the hours for each individual person posted as shown or a way that the hours can be posted like this and then have the total amount ...
2
votes
3
answers
2k
views
IF formula returns wrong value
https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx
We have Excel 2007 (German) and vista ultimate.
I am trying Excel by building a roster but have run into a problem with the following formula.
...
2
votes
3
answers
2k
views
Compare 2 sets of data in Excel and returning a value when multiple columns match
I have a data set for employees that contains name and 3 attributes (job function, job grade and location). I then have a data set for open positions that contains the requisition number and 3 ...
2
votes
2
answers
4k
views
Lookup multiple results for multiple criteria
I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
2
votes
1
answer
127
views
On Excel I want to create a list from another sheet based on two values
I have 2 values in dropdown menus in cells B2(DATE) and B5(ITEM).
from these values I want to create a list of items(based on B5) that were sold on that date(B2).
The transactions are listed on a ...
1
vote
3
answers
2k
views
Calculate average in excel excluding cell contains date or zero or text
In B6 I want to calculate average for range c6:h6 skipping cells which has date, zero or non text values.
Result should be - 400
I tried using averageif with filter ex: =AVERAGE(FILTER(C6:H6,ISNUMBER(...
1
vote
0
answers
57
views
Filtering Excel "files" that have unique values less than a specific number provided in a column
I have 1000 excel files with the same format. Some of those files have multiple unique values in a specific column, whereas some has only 8 to 10. At this moment, i open every single excel file, then ...
1
vote
0
answers
224
views
Formatting cell to show text in a text box. Excel Sheet
I have this sheet. The Product details section and the price section are not visible because of large amounts of text in them. When I manually make the size equal to the text..It becomes very ugly and ...