# 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.

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

2,214
questions

0
votes

0
answers

41
views

Hope somebody can make this task a bit easier for me.
Basically, i'm transferring notes from and Excel spreadsheet into our CMS platform. My main problem is the Excel entries are all on a single line, ...

0
votes

1
answer

25
views

I need to move page number from here
to here
Is that possible in Excel 2007? I'm not even sure what to search. To be clear, I know how create page numbers and how to position them in the basic sense....

-1
votes

0
answers

32
views

The dates in column B are in string type, I have:
Used Delimeters.
Formatting Cells to date form
Tried using the =DATEVALUE() and =VALUE() to extract the number value yet its gives the #value! error.
...

0
votes

1
answer

19
views

DATA SET PREVIEW
I Used the sum function to calculate the time, as the trip duration is in seconds i used =SUM(cell/60) and then convert them to HH:MM:SS, but some of the cells are returning 00:00:00
...

0
votes

0
answers

19
views

how to adjust values automatically if cell values A1 has changed means then the changed values has to adjusted with B2 values and the final cumulative values remains unchanged.
Suppose i have list of ...

0
votes

3
answers

55
views

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

1
answer

24
views

I am trying to link a column in a filtered sheet to another column in the master sheet using a key category (i.e., id). Below is the illustrated dataset:
[]
As shown above, I have the master sheet, ...

1
vote

1
answer

28
views

I have a bunch of formulas dotted about my excel tab that are of the form:
=cell_1+0.0049>SUM(cell_2:cell_3) for example-
=O10+0.0049>SUM(H10:N10)
I want to find all instances of these cells and ...

0
votes

1
answer

32
views

Let's say we have a formula in column B, for example =LEFT(A2; FIND(" "; A2)) but it could be anything else.
How to make that, when adding a new row in the future (here on row #4), the ...

1
vote

2
answers

27
views

Dim sht As Worksheet
Dim fnd As Variant
Dim rplc As Variant
Dim p As Integer
Dim q As Integer
p = 3
q = p + 1
fnd = "$3"
rplc = "$" & q
For Each sht In ActiveWorkbook....

0
votes

1
answer

24
views

My document has two relevant columns that I regularly do math on: Hours (B) and Client (D). I create weekly totals of the hours with the function =SUM(B15:B40). However, I also total the hours for one ...

0
votes

0
answers

29
views

So I have a simple vlookup formula to tell me if an item number is billable or not. However, when the value isn’t give(T or F) I do not get an output. However I want to use the invoice number (...

1
vote

0
answers

31
views

For reference, the Excel file in question: https://ufile.io/mlczqpkb
When I try and include the entire range of dates and river heights, it always cuts it off at 2014. If I slide the ranges down a few,...

1
vote

2
answers

54
views

I'm trying to sum up all the entries based on several specific conditions.
The goal is to count all entries that have a 'yes' ticked in them in cells J or K or L or M and have '1st' in H
This is the ...

0
votes

0
answers

24
views

here is what I have so far,
=if(A2="","",LOOKUP(A2-TODAY(),{-120,5,10,15,120},{"Critical","Critical","High","Medium","Low"}))
But ...

0
votes

1
answer

36
views

I have two due dates I have to look out for at work, and I want to have a priority column that assigns a critical, critical,high, medium, low , low priority if either of those dates are within -120 , ...

0
votes

1
answer

22
views

I want to highlight entire cell values when the row values changes.
For example, row contains
A
A
B
B
B
C
D
E
E
Final result : i want to highlight above the row by means of A has to in one color and B ...

0
votes

1
answer

30
views

I am trying to perform the same operation on excel on a range of non-concurrent cells.
Let's say I have range C:C, within this range I need to perform this operation IF(ISNUMBER(C2),(C2*A2),(0)). How ...

0
votes

1
answer

11
views

I'm having list of account numbers(AA, AAB, AAC, ADC) in column A in sheet 1 and also I'm having some common account number in sheet 2 (AAB,ADC)which is already available in sheet 1. Now i need a ...

0
votes

1
answer

37
views

So I have a column which has country names plus a few blanks.
So I want the formula to go by this :
IF the country name is "India" put it as India and if the country name is anything else ...

-1
votes

1
answer

50
views

I wants to add a auto serial number into my excel sheet which should restart from 1 automatically as soon as the text in the next column changed. For example I have column of subjects i.e English, ...

0
votes

0
answers

38
views

I have an attendance table that I need to verify every day. Every day different employees are billed on different projects, locations, and hours. Each has individual columns while the employees have ...

0
votes

0
answers

20
views

I'm trying to apply 2 different color gradients to the same cell. The gradients are based on other cell values.
When using conditional formatting, only one is applied.
If using VBA this code would ...

3
votes

3
answers

190
views

Let's say we have an Excel spreadsheet like this:
Is there an easy way, ideally built-in in Excel, to "unroll a row" to be able to:
have a better view of all the data in this row
have an ...

0
votes

1
answer

58
views

I have a sheet called 'Email' in which I reference cells from the sheet 'CL Upcoming'. What I am finding is that when I add new rows to the 'CL Upcoming' sheet that the new rows in the 'Email' sheet ...

0
votes

1
answer

54
views

I need to transpose the columns of data in this format:
Input.
A1
B1
C1
D1
E1
F1
A
W
1
2
3
B
X
1
2
C
Y
1
2
3
4
D
Z
1
2
3
Into this desired result:
Output.
A1
B1
A
W1
A
W2
A
W3
B
X1
B
X2
C
...

0
votes

1
answer

62
views

I've an excel-spreadsheet, which is my timetable. this means, that I've some tasks, which is almost always a connected cell, sometimes I connect 20 cells, sometimes only two. Example
Since every cell ...

0
votes

3
answers

474
views

Let's say we have a spreadsheet with all rows having the same default height.
In a cell, let's write Hello ALT+ENTER World. I indeed sometimes need to enter multi-line text in a cell, to write some ...

0
votes

1
answer

45
views

I have a column in an Excel table with datetimes in this format:
20211124_1502
I tried different formatting options for these cells (Date, Short date, etc.) but the date is never recognized/parsed (...

0
votes

0
answers

18
views

I have a problem saving an Excel spreadsheet. When I edit the table and click save, the changes are not applied. Only when I click Save As instead, the changes are applied.
The file is not opened read-...

0
votes

0
answers

43
views

I wonder if someone may be able to help.
I have a sheet with a list of events a person (email address) has attended and I'd like to extract/summarize the data in columns either at the end or on a new ...

0
votes

1
answer

38
views

I have some trading data as below :
I want to group data on some columns and do sum for Quantity and Average for price.
And output the data as SQL style like below.
How can i achieve this in excel. ...

2
votes

1
answer

56
views

I am using this an excel Gantt chart like this one, to name any: https://www.vertex42.com/Files/download2/themed.php?file=project-task-list-with-gantt-chart.xlsx
No matter what I try, the Gantt chart ...

0
votes

1
answer

62
views

I have tried to google the answer but fail to came up with any answers other than doing VBA. I am a user who do not have any knowledge of programming
I am trying to do an excel sheet to track a person'...

0
votes

0
answers

33
views

Or more abstractly, how can I use whole values for the ticks, but plot fractionally?
See screenshot showing the current chart with the days as ticks (it's currently charting the min/max per day), but ...

0
votes

2
answers

40
views

I use old Excel 2007 and have two columns. Column A contains 250 unique values. Column B contains 1000 values where some are duplicates.
If a value in column A is in column B, I want to highlight/...

0
votes

0
answers

34
views

So, suppose I have some data:
First name
Last name
Position
John
Orangeman
Kathy
Coolidge
Captain
Eric
Smarty
Sidekick
And then another 3 columns of related data:
First name
Last name
Position
...

1
vote

2
answers

64
views

We're creating a tool in Excel, using the .xlsx format, that we would like to provide on a broad basis as an open source document. Ideally, this spreadsheet should be usable to all Excel users, but we'...

0
votes

1
answer

34
views

I know how to plot each data set so that they all show up on the same chart together but the way I'm doing it is very labour intensive and will take a long time to do this for all sets of data (50+ ...

0
votes

1
answer

45
views

I'm sorry if my title is confusing, I'm fairly new to excel.
Below is a sample image, basically what I want to do is be able to filter the Topics. But when I filter to see -- Climate Change for ...

0
votes

1
answer

40
views

When I group by a date field, it formats the grouped field as a string and then sorts the recordset as a string rather than its actual value (see screenshots). When grouping by day, it turns 8/10/2021 ...

0
votes

0
answers

73
views

I want to copy a collumn on to another excel sheet where the first cell starts with: "Not Found"
If a cell in the first collumns contains "Not Found" I want to display them ...

0
votes

2
answers

56
views

I have two excel sheets:
-Sheet1 (Giant list)
C2: Application name
D2: Local Name
E2: Description
-Sheet2 (Less application and local names than in sheet2)
A1: Application name
A2: Local name
I want ...

-1
votes

1
answer

71
views

I am struggling days now to find a way to match two different tables in excel with the range of dates.
MY EFFORT on matching is :
=IF(AND($A2=$F2;$B2=$G2;$C2=$H2;$D2=$I2);ABS($E2-$J2)/$E2;"NO ...

0
votes

0
answers

40
views

I tried copying data from Excel to Outlook using VBA, the data gets copied. But the Excel sheets bottom line disappears in outlook.
Sub WSR_2cloumns()
Dim OutApp As Object
Dim outmail As Object
Dim ...

0
votes

1
answer

38
views

I am trying to reference a cell in my formula and the formula will accept values of number and "D" for days, "Y" for year, "W" weeks and so on. So for example I want to ...

0
votes

0
answers

74
views

I have a spreadsheet with multiple header columns and and the aim of the spreadsheet is to pick the value on the left hand side and place it in the correct column based on the description on the right ...

0
votes

2
answers

39
views

I'm am trying to filter a report by patients who have been seen 2021 but if the patient had visits in previous years too I want to exclude them from the report. (so if the patient has been seen in ...

1
vote

1
answer

208
views

In open office, the 'automatic' font colour option puts a light font in dark cells and vice versa.
Excel has the font colour 'automatic' available, but it appears to be exactly the same as just ...

1
vote

0
answers

48
views

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 ...