All Questions
38,821
questions
0
votes
0
answers
15
views
How to make a first class function cell in Excel
It is possible in excel to treat a cell akin to a first-class function?
For example, the typical behavior would be to set cell C1's value to =A1+B1 which is an immediate execution function. The ...
0
votes
1
answer
15
views
Using a matrix constant as input for control elements and validity
Given that you have in Microsoft Excel a matrix constant named Values defined as ={"One","Two","Three"}, how can I use the constant in control elements like listbox or ...
-1
votes
0
answers
31
views
Need help using index/match/vlookup
enter image description here
I need assistance creating a formula with match statement(s). My current formula isn't reading all my columns and gives me an "N/A" the moment I change "FOB&...
0
votes
0
answers
16
views
How to refer to the range of values of an Excel pivot table from a formula
I've got a pivot table with FieldR in Rows and FieldC in Columns, both with some values selected and others filtered out. I've got Sum of FieldV in Values, with values shown as % of Column Total.
I ...
0
votes
0
answers
23
views
Why don't values fit on the page in editing mode but do actually fit when printing?
In editing mode with the view set on "page break preview" some values don't fit on the page.
However, if I go to print, they fit on the page.
How does this work?
It might not look like it, ...
-2
votes
0
answers
28
views
How to cumulative average in excel? [closed]
i need to make an cumulative average for the price depends on the ticker name , and restart to cumulative average if the number more than zero value
0
votes
1
answer
14
views
outlook - how to search for specific time range
I would like to search macOS outlook for specific time range. Does anyone know how to do that?
received:1/1/24..1/10/24 after:12:00 AM before:5:00 AM
I found this page https://support.microsoft.com/...
0
votes
1
answer
33
views
Want to give more options in an IF formula
Current formula is
=IF(AND(RIGHT(A3,2)="00",B3="Vinyl",H3="No",I3="01 - UMGI",G3="Catalogue"),"8M Block required","None")
Instead ...
0
votes
1
answer
31
views
IF formula using vlookup
I am trying to create an IF() formula using VLOOKUP(), my VLOOKUP() is this
=VLOOKUP(A14119,'CoO Flags Report'!D:L,9,0)
but I want it to state no if the VLOOKUP() finds #N/A
0
votes
0
answers
17
views
MS Outlook Invitation going to wrong email address
I've recently started having an issue sending to contacts with 2 emails in their contact record - both in the CLient and Web versions.
I try to send an invite to email address 1, but it insists on ...
0
votes
0
answers
32
views
Finding values in Column A that aren't in Column B [closed]
I have two large datasets and I am trying to identify values from Sheet 1 column D that do not exist in Sheet 2 column D, I've seen lots of answers for the same table, but if they are two different ...
1
vote
3
answers
67
views
How do I sort an Excel sheet vertically = reverse the order of the full sheet = put the sheet bottom up = turn the worksheet upside down
Data in an Excel sheet needs to be sorted the other way round. I cannot sort the data by the two columns date and time since there are some lines in it that do not have the same pattern, for example ...
0
votes
0
answers
30
views
Linking columns on different sheets
I'm very new to VBA coding (only dabbling for this specific project), so I would really appreciate any advice on an issue I'm having. I'm attempting to independently link multiple column ranges on ...
-1
votes
1
answer
31
views
Hiding "display values", the numbers 45396 are showing where there is no data entered into the cell. How do I hide this?
enter image description here
Image for explanation. I used the =days(end,begin) formula to calculate the number of days that has lapsed since servicing. HOW DO I HIDE THE 45396 number?????? Super ...
0
votes
1
answer
58
views
What gives Excel/csvs their formatting functionalities?
When I open a csv file by double-clicking it, it opens, and as one would expect, displays the data in a big array of cells with a ribbon of formatting options at the top (Clipboard, Font, Alignment, ...
0
votes
3
answers
182
views
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
I know that there are questions around that are much the same, like Sum the number of hours in Excel, which asks you to format [h]:mm, which I do and it still does not work.
Also not so far is How do '...
0
votes
2
answers
64
views
MS Word, how to manage the Headings in a document
In Word, I can press CTRL+F to go to Navigation, and then press the "Headings" tab in there to see section headings, which is quite useful. However, I noticed that not every heading was ...
0
votes
2
answers
48
views
Pivot table in excel: get difference of two rows in original table as a value
I have a huge table that looks something like this:
Period
Retailer
Area
Section of people
Goods type
Metric 1: Quantity sold
q1
some dude
area1
1
doll
111
q2
some dude
area1
1
doll
100
q1
some ...
0
votes
1
answer
27
views
Chain array formulae
Is it possible to chain array formulae?
i.e.)
Assume a column of values such as "Max", "Michael", "Kyle", "Michael" starting in A1
Then a formula such as =...
1
vote
2
answers
23
views
How to paste all PowerPoint slides to Word?
I need to paste all PowerPoint slides into a table in Word, but each slide must be in a separate block?
Is this possible or must I copy and paste each slide on their own?
1
vote
1
answer
25
views
How to vlookup all columns and sum
I have two table.
The first table contains menu and price:
Menu
Price
Pizza
20
Pie
10
Beer
5
Burger
10
The second one contains a buyer and menu. I want to get the sum of price based on menu like ...
0
votes
0
answers
35
views
How can I copy a range of cells to my actual column?
I have this Excel sheet A:
And this Excel sheet B:
What I need is to copy all content from Excel B sheet from A2 to A6 to the selected cell of sheet A, in this case A1. This would be the result by ...
1
vote
1
answer
16
views
Excel formula - returning a list of values from multiple criteria
I’ve had a real struggle with this one and can’t crack it for the life of me.
I need to create an excel formula that does the following:
*Looks for all Values in Forces!A1:A5000 that match the value ...
1
vote
0
answers
34
views
Calculate the average wait in days with a condition based on another column
I'm trying to calculate the average wait for a location in days. I have managed to calculate the average wait for a person in days using
=DATEDIF('Jun24'!V8,'Jun 24'!AA8,"d")
This gives me ...
0
votes
2
answers
28
views
What does the recipient see if recall Outlook email fails?
If you and the recipient are on the same Exchange server and you recall an email you sent but the recall fails, what do they see?
Ideally, I'd want them to see nothing. But it sounds like maybe they ...
-1
votes
0
answers
20
views
ForFiles export file
I would like to run the following and hopefully be able to see the total size of all of the data being deleted.
forfiles /p "C:\randomfilepath" /s /m *.* /D -180 /C "cmd /c echo @file @...
0
votes
0
answers
25
views
Unknown object in Excel 2021 cells
In creating a very simple excel sheet in Excel 2021, I am now seeing a small bold cross (Not the one for copy/drag) in several cells. It will neither cut nor delete. It does not enlarge or change with ...
0
votes
0
answers
38
views
Outlook Blocked senders mail list
I've developed an Outlook add-in that moves selected emails to the junk folder and creates a text file containing the reported email addresses. I aim to use this text file as a blocked senders list. ...
0
votes
0
answers
18
views
put escalated cost value into every nth column [closed]
I Have a list of items Col A, with current cost Col B, that get replaced in varying years (7, 10, 20 etc.years) Col C.
I have an escalation formulae.
I have 30 years in row at top.
Need to know Excel ...
0
votes
1
answer
18
views
Excel formulae to use conditional formatting each cell in a column which is < or > than the 4th column to the right of that cell
I have a spreadsheet where each cell in each column is compared to the value on the same row in the 4th column from the right and should the value be greater or smaller the font colour is changed ...
0
votes
3
answers
45
views
Microsoft Excel: Highlight decimal higher than .00
I am trying to highlight a cell based on the point decimal value. I understand how to highlight the point decimal with a MOD function but exclude a full value.
The data is quite simply based on ...
1
vote
1
answer
24
views
limiting excel columns to a maximum
After I import a csv file and double-click to make the columns wide enough to show data for each column contextually, many columns are way too wide.
Is there a routine I can run in an xlsx file that ...
0
votes
1
answer
38
views
Excel conditional formatting not applied to all cells as configured in "applies to"
The following (link to a) screenshot shows that I have applied conditional formatting to cells O5 through P8 based on the value in column M (of their corresponding row)...
It can be seen that the ...
5
votes
2
answers
204
views
How do I exhibit the character Ň (U+0147) in my Word 2010? Why the method described in the first paragraph below doesn't work for this character?
As far as I can understand, to exhibit a Unicode code point in Word, one should press the Alt key, followed by the character + and the Unicode code point, both typed in the numeric keypad. That’s ...
0
votes
1
answer
14
views
Trying to concatenate a row and variable columns
I'm trying to concatenate a static row and column data that is variable. In Column A1 is Job Roles. So in A2 the value is "Security Analyst", in A3 the value is "Security Engineer&...
0
votes
1
answer
44
views
How to add cell color based of values with color gradient from red to yellow to green with a formula
I have values like this:
If the values are higher than -5 or +5 they are also red. everything towards 0 gets greener like the screenshot.
Formatting with the conditional format for each column is a ...
0
votes
1
answer
24
views
Word shows Print Preview but won't send anything to any printer, even a PDF writer [closed]
I edit or create a document in Word. I check the print preview which looks fine. When I select Print I just return to the editing view. It's not a printer problem because:
the printer works with ...
0
votes
0
answers
61
views
Need help to optimize my VBA code
What I'm trying to do is I want to copy the rows to each different type based on record type.
Raw file tab - there are hundreds of thousands rows of data containing 6 different record types.
PRPO TAB -...
-1
votes
0
answers
27
views
Automatically populate a template in excel from table with input values
I would like to have an table with input. Press a button. And use excel to generate 1-20 lines with the same input. For every row of input there are 3 output lines.
Simplified Example input table:
...
-1
votes
1
answer
34
views
Excel formula that allocates weight into 3 different sized containers
I have an excel sheet that i use to calculate a raw material cost per kg for my customer.
effectively i want the excel sheet to calculate how many jerry cans are needed for the total weight of the ...
0
votes
1
answer
20
views
In outlook, how to properly display incoming internet-style quoted messages
I send my messages using 'text' and old school 'internet-style' quoting in Thunderbird, like
I have a question
I know the answer
I have another question
Sorry, I don't know that answer
Clients ...
0
votes
0
answers
22
views
Word document with two inserted excel spreadsheets, cross referencing cells between them
I have a word document in which I have inserted two separate excel spreadsheets using the Insert tab, then Table button, then Excel Spreadsheet in the drop down menu in Word. Let's call them sheet1 ...
0
votes
1
answer
33
views
Conditional Formatting starting and ending based upon cell values in a range
In a given range of x by y cells, I'm looking for a formula that will format cells in a row starting every time a cell value is "x" and ending every time a cell value anywhere in the range ...
0
votes
0
answers
49
views
Why am I not receiving e-mails when someone uses auto-fill in Outlook?
I just noticed that whenever someone uses auto fill for my name or e-mail address in Outlook, I don't get any e-mails. I saw that people had such issues earlier, but I was able only to find similar ...
0
votes
0
answers
23
views
Excel Pivot Table On Separate Row
Is there anyway I can make the Contract Value Covered it's own separate row instead of being a column?
enter image description here
0
votes
1
answer
65
views
How to count instances of repeated values in a cell range while ignoring blank cells
I have a dataset of subjects (one per row), each with scores taken over several days. Each day has multiple scores, but the number of scores varies such that there are many blank cells.
See a small ...
2
votes
3
answers
99
views
MS Word, cannot remove final blank page - Table at the end of document
On the last page of my Word document that I have text, I have a table. This table ends about an inch from the bottom of that page. However, Word has then decided that it will insert a completely blank ...
0
votes
1
answer
60
views
Join/Mix dynamic and static values on Array = alternative to HSTACK that works in older MS Excel version (No VBA, please)
I need to join some value(s) from some cell(s) with a "static" bunch of other values into an Excel array... BUT I'd like to avoid using VBA for it and I need something that works also with ...
0
votes
1
answer
24
views
How to find and replace superscripted Numbers wrapped in square brackets in Microsoft word
I need to find all superscripted numbers wrapped in the square brackets like this [23] for example but for any number up to 90. Because I cited some references like [1] down to [90]
but now I need to ...
0
votes
0
answers
19
views
How to convert a list or a table of latex equations into word format
I try to convert automatically a large table of latex equations into a word table. How to do that automatically, without having to select cells, one one by one and click on convert to professional ...