Questions tagged [microsoft-excel-2007]
Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.
2,270
questions
1
vote
0
answers
13
views
Excel linked data formula giving different solutions after updating to new computer
As the title states, my work computer has been updated to new system (Windows 11) and I've tried my best to arrange all the files and folders in the same way they were previously, but am still running ...
0
votes
1
answer
23
views
Use Excel to get only the cycle start date
I have the following data in Excel:
Date
Status of Lab1
Status of Lab2
01-01-2024
On pause
Pausing
02-01-2024
Started
Pausing
03-01-2024
Started
On pause
04-01-2024
Started
On pause
05-01-2024
...
4
votes
1
answer
162
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
0
votes
1
answer
79
views
In Excel is there a way to “turn on and off” the =min in a formula?
I am creating a budget spreadsheet in Excel and in some instances I will need the formulas in the spreadsheet to include the =MIN and in some instances I won’t. For example, the formula is:
=MIN(...
0
votes
2
answers
68
views
Copy paste the values of cells from Excel
I want to copy paste the cell values what we see post pressing F9 in a cell into word. Is there any short and quick way to do this?
For example - if I have a formula:
=AVERAGE(E12/H12,E11/H11,E10/H10)
...
0
votes
1
answer
88
views
How to compare two columns in Excel with a conditional IF statement?
I have three columns that have some expense figures: Actual (column A), Budget (column B), Variance (column C):
For these expenses, if Actual is greater than Budget, I want the variance column result/...
0
votes
1
answer
114
views
Formula for Matching Header to Value
This is a question that I may have difficulty explaining, so bear with me.
On one sheet I have a column which has several cells, some of which are blank, some that have a single value, and some that ...
2
votes
1
answer
130
views
Find uniques and show corresponding values as comma separated values in Excel?
I have a table with large data containing family name and family households. And I am trying to get them in a unique list followed by the household names as comma separated values.
The table below ...
0
votes
1
answer
39
views
Protect Excel workbook WITH password AND share with NON-DEFAULT advanced parameters
In Excel 2007 it seems like I can do one of the two things separately, but not together:
I can share the workbook with non-default advanced parameters but without a password protection (Review->...
0
votes
0
answers
50
views
How can I easily make a chart showing what weeks a task was completed or not?
I'm trying to make a chart that shows who completed an inspection for each week. At my work, we run Sunday to Saturday and within that time period, we expect our guys to submit a truck inspection.
I ...
0
votes
1
answer
67
views
How to count the number of cells that contain certain text while excluding cells that start the same but end different
In our company, the truck numbers in our database all start with "TK" A regular truck would be "TK123" for example. We also have stipend trucks and these all start with "TKPB&...
0
votes
0
answers
54
views
Unable to edit the required text and update auto-date
I Should be able to edit any text updated except , "Posted", "Closed" in J Column. Every time I edit the text the date should be auto updated in next column cell. For example, I ...
0
votes
1
answer
274
views
How to Autoincrement the Column index number by dragging VLOOKUP formula down
I need to drag a Vlookup down and have the Column index number in to increase by 1 every row I drag it down.
So for example:
Row 1:
IF(VLOOKUP(A2,'Jan 2024'!$D:$BP,**35**,0)<=0,"IGNORE",...
0
votes
1
answer
76
views
Autocomplete Excel formula with keyboard shortcut
When typing the beginning of a function name in a Excel formula, there is a list of suggestions:
How to accept the currently highlighted suggestion, and autocomplete it with a keyboard shortcut, ...
1
vote
2
answers
571
views
Comparing two different data sets
I’m looking for advice on how to compare two different worksheets for differences, perhaps by the highlighting of differences on one sheet. The issue is that the data set I’m comparing to is in a ...