Skip to main content

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
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 ...
felipe's user avatar
  • 3
4 votes
1 answer
149 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, ...
Beef_tataki12's user avatar
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(...
EMD's user avatar
  • 1
0 votes
2 answers
66 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) ...
Naive_Natural2511's user avatar
0 votes
1 answer
82 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/...
Samantha Lima's user avatar
0 votes
1 answer
109 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 ...
chunky-coal's user avatar
2 votes
1 answer
118 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 ...
DigitalNomad's user avatar
  • 1,708
0 votes
1 answer
38 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->...
Regus Pregus's user avatar
0 votes
0 answers
49 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 ...
Cole's user avatar
  • 3
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&...
Cole's user avatar
  • 3
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 ...
raju nagavelli's user avatar
0 votes
1 answer
243 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",...
Owen210's user avatar
0 votes
1 answer
73 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, ...
Basj's user avatar
  • 1,900
0 votes
2 answers
542 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 ...
Lena278's user avatar
0 votes
3 answers
150 views

How to count for between two dates in 2 colums with different row in Excel

I have a spreadsheet with 2 columns with dates and one with a Room #: Date In Date Out Room No 2/3/2023 2/5/2023 Room 1 2/5/2023 2/8/2023 Room 1 2/8/2023 2/10/2023 Room 1 3/23/2023 3/26/2023 Room ...
Chris's user avatar
  • 1
0 votes
1 answer
61 views

Excel - AverageIfs with multiple valid criteria in different columns

I'm trying to get excel to give me the average of multiple objects if they meet a criteria. I want to calculate the average of the last column (SLA in days) for the lines that contain Country=ES/PL, ...
Monik's user avatar
  • 1
0 votes
1 answer
65 views

Why am i having a #value in my index excel formula?

I am trying to create a formula With Index excel but there ia something wrong and i can't figure it out , below is my formula =INDEX(TABLES!$D$98:$S$189,MATCH(1,($C$3=TABLES!$D$97:$S$97)*($C$4=TABLES!$...
Vera Aramouni's user avatar
1 vote
1 answer
3k views

References to blank cells become 0's

I have a spreadsheet in excel where I need to make some references to an area in another spreadsheet. I simply use ='EARTH'!B9:N323, which is an area mixed with some columns of text and others of ...
BearCoder's user avatar
0 votes
1 answer
78 views

How to stop numbers from automatically opening hyper links in Excel?

So I have ID numbers that I hyper link to a website. It's automatically hyperlinking the whole cell, preventing me from editing the text by double clicking the cell. For example, let's say I have ...
Danny P's user avatar
0 votes
0 answers
57 views

Formula to Round Down Number in cell

I need to round down the highlighted numbers in Column Q of the attached screenshot. I currently have formula of P/F starting on Cell Q5 through Q46. I am diving the quantity on hand for each part ...
Juan P.'s user avatar
  • 13
0 votes
0 answers
311 views

Excel Solver Error: The objective cell values do not converge

I've been consistently getting the error above when trying to get the parameters for my logistic regression Does anyone have any ideas why this may be happening? I see that the solver is making the ...
user avatar
0 votes
1 answer
475 views

Excel Help - If two cells meet a certain criteria input a value into another cell

I'm a bit of an excel beginner so apologies in advance. I need my worksheet to automatically input a price into a specific cell. I have a table in one sheet which has tables for each product brand and ...
Paris Golding's user avatar
0 votes
2 answers
180 views

Round each instance in Sumproduct before sum

I am trying SUMPRODUCT Formula on lets say Column A and Column B. Column A has Patient referrals and Column B has percentage referred for each hospital. I am using this syntax: ROUND(SUMPRODUCT(A1:A10,...
Ammar's user avatar
  • 1
-1 votes
1 answer
69 views

How to generate a table of names based on complicated criteria in Excel

Screenshot: Hi experts, I am trying to make a table in Excel that can generate a "Doc #" for each day of the month (for Monday to Friday only) based on availability. I've included a ...
EOCZ9's user avatar
  • 1
1 vote
1 answer
1k views

Why are my columns disappearing after I refresh the data?

The table below is connected to a query. When I refresh the table below, the last two columns' data, S and T, disappear. All the cells in these two columns contain a vlookup. How can I get the vlookup ...
anon1212's user avatar
0 votes
0 answers
1k views

I am trying have data appear in the "Values" field in a pivot table, but the pivot table keeps summing the values that have the same date

In the pivot table, when there are two or more values assigned to a date, they sum. I don't want the values to sum. I want each value listed, even if the date is same for the values. I've tried going ...
anon1212's user avatar
0 votes
2 answers
63 views

Excel - Formula Based Individual Durations and Total Duration Calculation from Slash-Separated Time-Strings

I am trying to calculate (using worksheet formula based solution only) individual time-durations and total time duration from the slash '/' separated time-texts in two cells (each value of first cell ...
the Explorer's user avatar
-2 votes
2 answers
11k views

Conditional Formatting with greater than & less than parameters based on date in cell

Trying to conditionally format a cell based on the date in the cell. My ultimate goal is to try and track warranty expiration dates on some of the product we maintain. Within 30 days of expiration ...
LonlyBoy's user avatar
0 votes
1 answer
27 views

Is it possible to seperate cells like based on a variable?

Here I have 2 pages one named Input and The other Output in Input I have In cell C2 the number of lanes which is 6 in this example and the D2 the number of Heats which is currently 4 : if this ...
Tafa Tic's user avatar
0 votes
1 answer
153 views

Creating Exception in Excel Sum to Avoid error Value

this is the formula: =DATE(YEAR(Q14),MONTH(Q14),DAY(Q14)+(R14)) I'm using to add date how do I make exception that it keep the answer blank until I enter the date in Q column
Karthik's user avatar
0 votes
1 answer
50 views

Excel/LibreOffice Calc - Setting a value dependent on another value as that second value rises at a uniform rate

Essentially the value in C24 is dependent on the value in C18. The value in C24 should be 33 if the value in C18 is 2230 or less. The value in C24 should be 39.5 if the value in C18 is 2950 exactly. ...
ShadowLine's user avatar
0 votes
1 answer
452 views

Can anyone please tell me how can I convert 1M, 1B, 1K to number format in excel? [duplicate]

Can anyone please tell me how can I convert 1M, 1B, 1K to number format (like 1K = 1000) using formula in excel. Advance thanks for help.
Somendu Paul's user avatar
0 votes
1 answer
71 views

How to connect the color of a legend in a horizontal chart for two groups?

I am trying to display the results of the performance of a set of rooms based on their responses to a test. My goal is that the results above or equal to 50% to be marked as achieved results and those ...
Chris Steinbeck Bell's user avatar
0 votes
2 answers
4k views

#VALUE! Error when trying to use the Filter function to filter on mutiple criteria

original_name match_name_0 score_0 match_index_0 match_name_1 score_1 match_index_1 AGI Partners, LLC agi partners llc 100 5273 agi partners llc 100 5273 AXA Investment Managers S.A. axa investment ...
novawaly's user avatar
  • 123
0 votes
0 answers
24 views

Have problems sharing an Excel Sheets

I am working on an Excel Book and I want to share it with some people. All the Sheets are linked to another Excel Files, so I need some help with sharing this Excel without any #REF or ERROR in the ...
Santiago's user avatar
0 votes
0 answers
46 views

Excel formula to look at a Row

I wrote an excel formula to return(true and false) if three criteria's matched in the row. For ex) If the Row contained Name , D, and 1 then it is true This is the formula created: =IF(AND(COUNTIF('...
user1762802's user avatar
0 votes
2 answers
653 views

Splitting a column in excel into two columns keeping the leading zeros

Trying to find a faster way to change this format from one column (A) split into 2 columns (B and C) as in the example below: A B C 978-BD71151-001-0 978-BD71151-001 0 978-BD71151-002-1 978-...
Elysia's user avatar
  • 1
0 votes
1 answer
239 views

Color rows alternatingly according to change in column value – without hidden columns?

I have an Excel sheet with multiple columns, where in one column subsequent values can be identical or different, so that the rows form a number of groups. I would like the rows belonging to a group ...
A. Donda's user avatar
  • 849
0 votes
1 answer
414 views

How to put DATEDIF and IFISBLANK together?

I have 3 total cells I'm working with. One houses today's date (A1), the second has the date the request was made (B1) and the third has the date of the event (C1). My team had previously used DATEDIF ...
Inga22's user avatar
  • 1
0 votes
0 answers
64 views

SUMPRODUCT Query

I'm trying to use SUMPRODUCT or any other formula to get an end calculation of how many occurences "Louise" appears in column F and then how many Sessions she had in the MONTH of September ...
thistleburden's user avatar
0 votes
0 answers
159 views

Call a sheet using a variable name

I have this code in wich I add a sheet with a certain name and then I need to call this sheet to get a cell value but it doesn't assume. Dim nome1 As String Dim tableName As ListObject Dim addedRow As ...
Luís Rodrigues's user avatar
0 votes
1 answer
695 views

Drag down formula from multiple sheets on one sheet

I have 19 Sheets on each sheet in cell B17 I have a result. On my first sheet I have cell numbers from 1-19. In my first sheet I type in cell one the Formula ='sheet 1'!$B$17. I have the number in ...
lee's user avatar
  • 1
-1 votes
1 answer
105 views

multiple codes in a cell to convert to text

I have a cell which contains multiples codes that are pipe delimited - up to 5 codes. Additionally, I have a decoder for the codes on a separate excel sheet. I basically want to replace the codes with ...
LIH's user avatar
  • 11
0 votes
1 answer
262 views

running 2 excel versions at once, cant associate filetype to older version

I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...
chiliNUT's user avatar
  • 1,173
0 votes
0 answers
120 views

How do you generate a list on excel based on complex criteria when the data set is not unique?

I am trying to build a excel sheet that automatically generates the list based on the 3 criteria (each criteria has a dropdown). Below is the template I created. Criteria list: Purpose, loan type and ...
P1_LO's user avatar
  • 1
0 votes
0 answers
91 views

Excel 2016 to open in the same place we closed it, like Excel 2010

Slow to the game, I know, but I just upgraded to Office 2016 from Office 2010. In 2010 when I opened Excel, it opened on the same screen, in the same position, no matter how many instances I opened......
mikem's user avatar
  • 476
0 votes
3 answers
683 views

How to create a list of items in an Excel cell, and be able to data filter this column?

Can we have a list of items in an Excel cell, such that the rows can be filtered with Data Filter? Exemple: how to filter by column B and keep only the rows that contain [item4]: ? Notes: we could ...
Basj's user avatar
  • 1,900
1 vote
1 answer
50 views

An Excel sheet that will have 2-3k columns and 100 rows, is it better to use vlookup/hlookup or index/match from an efficiency/size perspective?

Thinking about sheet design and unfortunately, it looks like it's going to have a lot of rows and columns that will have to be looking up values. From a size/speed/efficiency perspective, is it better ...
novawaly's user avatar
  • 123
0 votes
1 answer
2k views

How to set the language for formulas to English instead of the default Excel language?

Excel 2007 is installed in French language. So all formulas are in French, which is not handy: =RECHERCHEV(...) instead of =VLOOKUP(...) Question: how to set the language to English for formulas, ...
Basj's user avatar
  • 1,900
0 votes
1 answer
101 views

How to reference specific cell location for conditional formatting

I'm trying to make the conditional formatting to reference each cell location that is visible. (It has been filtered) ActiveSheet.Range("A1:P24").AutoFilter Field:=3, Critical:="Tuesday&...
ebgoodman's user avatar

1
2 3 4 5
46