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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

How to split text from one cell into multiple cells

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, ...
user avatar
0 votes
1 answer
25 views

How can shift page number all the way to the edge of the margin in Excel 2007?

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....
user avatar
-1 votes
0 answers
32 views

String value of date not converting and returning error

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. ...
user avatar
0 votes
1 answer
19 views

SUM function returning 0 value

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 ...
user avatar
0 votes
0 answers
19 views

Auto adjust cell values if one cell values changed

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 ...
user avatar
0 votes
3 answers
55 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(...
user avatar
  • 101
1 vote
1 answer
24 views

Is it possible to link an entry in a filtered sheet to the master sheet, matched on a key variable? (Excel)

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, ...
user avatar
1 vote
1 answer
28 views

How to append to formula if a condition is met in microsoft excel?

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 ...
user avatar
0 votes
1 answer
32 views

Automatically duplicate the same formula when adding new rows

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 ...
user avatar
  • 1,696
1 vote
2 answers
27 views

FInd Replace value of a formula in excel but incremental and loop

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....
user avatar
0 votes
1 answer
24 views

Excel 2007: How to infer the range to use in a function from that used in another function

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 ...
user avatar
  • 101
0 votes
0 answers
29 views

Excel formula add on needed for vlookup

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 (...
user avatar
  • 1
1 vote
0 answers
31 views

Excel 2007 line chart won't add dates past 2014 when using full data range

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,...
user avatar
1 vote
2 answers
54 views

Converting positive number values to boolean TRUE in excel

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 ...
user avatar
0 votes
0 answers
24 views

Prioritizing work based on 2 expiration dates in a2 and b2

here is what I have so far, =if(A2="","",LOOKUP(A2-TODAY(),{-120,5,10,15,120},{"Critical","Critical","High","Medium","Low"})) But ...
user avatar
  • 3
0 votes
1 answer
36 views

Microsoft Excel- prioritizing based on two date columns

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 , ...
user avatar
0 votes
1 answer
22 views

Highlight entire rows based on cell values

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 ...
user avatar
0 votes
1 answer
30 views

How to perform same operation on non concurrent excel cells

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 ...
user avatar
  • 3
0 votes
1 answer
11 views

Excel macro to highlight common values between two different sheets

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 ...
user avatar
0 votes
1 answer
37 views

Tried multiple IFS formula. None is working

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 ...
user avatar
-1 votes
1 answer
50 views

Restarting excel serial number

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, ...
user avatar
0 votes
0 answers
38 views

Combine then count combination of text in cells in a table

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 ...
user avatar
0 votes
0 answers
20 views

Excel VBA: how to apply 2 color gradiants to the same cell based on cell values?

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 ...
user avatar
3 votes
3 answers
190 views

How to unroll a row in Excel, to have a better view for editing?

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 ...
user avatar
  • 1,696
0 votes
1 answer
58 views

Conditional Formatting not updating when referencing new data from another sheet

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 ...
user avatar
0 votes
1 answer
54 views

Concatenate sequential column cells into row cells

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 ...
user avatar
0 votes
1 answer
62 views

Excel: Count Weighed Cells

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 ...
user avatar
0 votes
3 answers
474 views

Prevent Excel to automatically "Wrap text" in a cell

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 ...
user avatar
  • 1,696
0 votes
1 answer
45 views

Recognize datetime in 20211124_1502 format with Excel

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 (...
user avatar
  • 1,696
0 votes
0 answers
18 views

Excel doesnt work with "saving" but "saving as" works

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-...
user avatar
0 votes
0 answers
43 views

Extracting Totals and Summary of raw data

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 ...
user avatar
  • 1
0 votes
1 answer
38 views

Group multiple excel rows just like SQL

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. ...
user avatar
  • 103
2 votes
1 answer
56 views

Excel Gantt chart: time line fixed start 1st each month in major steps?

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 ...
user avatar
0 votes
1 answer
62 views

How do i auto change a cell upon entry of a another cell

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'...
user avatar
0 votes
0 answers
33 views

Excel 2007: How can I use days for chart axis ticks, but plot on time?

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 ...
user avatar
0 votes
2 answers
40 views

Highlight all numbers in column B with duplicates that are in column A?

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/...
user avatar
  • 151
0 votes
0 answers
34 views

Combining sets of columns without duplicates but while filling in blanks

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 ...
user avatar
1 vote
2 answers
64 views

Share of current Excel users who can only open .xls files? [closed]

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'...
user avatar
0 votes
1 answer
34 views

Excel plotting many data sets each with their own x-axis values on the same graph

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+ ...
user avatar
  • 1
0 votes
1 answer
45 views

Filtering entries in Excel with multiple connected data on adjacent column

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 ...
user avatar
0 votes
1 answer
40 views

How do I sort pivot chart groups by their actual value, not their stringified group name?

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 ...
user avatar
0 votes
0 answers
73 views

If Cell Contains Text Then Copy to Another Sheet

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 ...
user avatar
  • 1
0 votes
2 answers
56 views

Compare two sheets in excel

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 ...
user avatar
  • 1
-1 votes
1 answer
71 views

matching range of dates in two different excel tables

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 ...
user avatar
0 votes
0 answers
40 views

Copy data from Excel to Outlook using VBA, data disappears

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 ...
user avatar
0 votes
1 answer
38 views

How to put < -> negative sign and a number and letter in one cell?

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 ...
user avatar
0 votes
0 answers
74 views

Is there a formula or function i can use assign a value to column based off the criteria in another cell?

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 ...
user avatar
0 votes
2 answers
39 views

Excel FIltering by multiple criterias

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 ...
user avatar
  • 1
1 vote
1 answer
208 views

In excel, what is 'Automatic' as a font colour? Behaves as black does, even on black cells

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 ...
user avatar
1 vote
0 answers
48 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 ...
user avatar

1
2 3 4 5
45