All Questions
18
questions with no upvoted or accepted answers
1
vote
0
answers
87
views
Hours turned/paid/worked
I am attempting to create an Excel sheet that provides a few calculations based on three things:
Hours turned by specific technician (4 different techs)
Amount of hours worked by each tech (up to 8 ...
1
vote
0
answers
304
views
What does ' '!$A$1 means in Excel?
While looking for a dynamic tournament-schedule in Excel, I stumbled upon this formula:
=IF(' '!$A$1=0;D7; ...)
Usually, I use the "!"-Operator when referring to another worksheet.
What ...
1
vote
0
answers
42
views
How best to find next/last meeting across multiple Excel sheets?
I'm pretty rusty on my excel and have been asked to help someone with a slightly tricky problem.
We have a number of projects going on where we are meeting the same companies for different reasons. To ...
1
vote
0
answers
221
views
Excel INDEX MATCH across 2 sheets & Update data with VBA
I would like some help with the following tasks.
I will in the future add an additional sheet with 3 columns. A would be a date, B a Wo number and C would be the date which the Wo was closed by ...
0
votes
0
answers
68
views
Need Help Migrating A Drop Down List From One Workbook To Another
I need some help migrating a drop down list and the data selected from that list to another workbook.
I have a list of people that need to be contacted each week, with an updated file that is sent to ...
0
votes
2
answers
166
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
0
votes
0
answers
80
views
Creating a technical excel data sheet to display efficient data
I am creating a table in excel that holds milestone achievement data with their respective amount. This table has multiple milestones that have only one amount, meaning that a set of milestone ...
0
votes
1
answer
70
views
Excel Sum Table based of criteria missing from another table
I have 3 tables. Table1 is a list of items w/ a sum attached to them.
Table 2 is a list of "official items" and a category.
Table 3 is a category that needs a sum.
i.e.
Table 1
A.
B
Parrot....
0
votes
1
answer
377
views
Autofill Blanks with Zeros if no other Numeral Present
I have a working system for giving employees an opportunity to track their goal progress on a week to week/monthly basis. I've now protected all cells except the 'Monthly Admission Goal' and grid ...
0
votes
0
answers
1k
views
Evaluate function not working
In the example, entering the combined values in K2 as a formula produces the result in J2. J2 is value copied and pasted in J4. To confirm that it is a formula that will not produce an error, the ...
0
votes
1
answer
1k
views
How to transpose and skip cells?
thanks for being so helpful. I have columns where every 6th column had an alphabet letter: a b c d e f, so that column 1 has letter a, column 7 has letter b. I want to transpose that into rows of a b ...
0
votes
0
answers
2k
views
EXCEL: Can I reference text within a cell, for a file path, in a function?
I have the following VBA module in Excel which allows me to do check if a file exists in a given folder:
Function FileExists(FilePath As String) As Boolean
'Declare variables
Dim FileName As ...
0
votes
0
answers
334
views
Why are array formulas not filling adjacent cells as they should?
When using formula arrays with multi-cell results, the returned array is outputted in the adjacent cells as the formular arrays (as I've experienced in the past and as documented).
Why is it that if ...
0
votes
1
answer
1k
views
How to add value to same cell in Excel
I frequently do stock audits in my store by scanning barcodes into Excel. I use the Vlookup() function to avoid data errors. At times, I scan the same barcode again and again, always adding just one ...
0
votes
1
answer
80
views
Excel: Data across multiple columns and rows
Currently have a table like this:
How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...