All Questions
3,348
questions
0
votes
0
answers
15
views
IF AND and conditional formatting question
I am trying to find the right formula for the below situation. Not sure if conditional formatting is the answer or a formula or a combination. I have reviewed guidance for how to use IF and IFS as ...
-3
votes
0
answers
26
views
Excel - Way to map out charging info for a team that ultimately max's out at 40 hours and redistributes reduced funding to other assigned members [closed]
I'm looking for a better method of accomplishing my goal, I'm entirely open to a complete overhaul of what I have now.
I'm part of a team of 70+ members that support numerous programs, and even more ...
0
votes
1
answer
40
views
Excel trailing zeros
Given this formula in excel =TEXT(ROUND(R22,C13),"0.00")
How do I make so that "0.00" is calculated automatically depending on the number of digits inputted in C13.
Ex1
C13 = 3
and ...
0
votes
3
answers
68
views
I need an excel formula that if a number in cell A1 is 1,2 or 3 then put number 8 in cell A2. If not leave blank
I need an excel formula that if a number in cell A1 is 1,2 or 3 then put number 8 in cell A2. If not leave blank.
I tried a bunch of formulas but I don't know what this one would be called. Sounds ...
0
votes
0
answers
19
views
How to set time interval between automatic calculations in Excel
I have a spreadsheet which source data from external sources and many formulas depends on these source data. The source data are updating frequently (sub-second), but my spreadsheet is too heavy to ...
0
votes
0
answers
39
views
REF error in libreoffice calc, when trying to get address from another book
I need to get address from anoter book in LO calc. I do that in excell with success, but calc return me a ref error. I use 3 functions: match, index and cell.
calc
=CELL("address";INDEX('...
0
votes
1
answer
25
views
How to find the three largest values among cells in different columns in Excel in Portuguese?
I'm trying to calculate the three largest values among cells that are distributed across different columns in Excel, using the Portuguese version of the software. The cells I want to compare are in ...
0
votes
0
answers
29
views
IF V16 is greater than 0, does S5=D17? True do nothing, False highlight
I want to get a cell to highlight is the value in cell V16 is greater than 0. I then want it to check if S5=D17. If this is True, no action is required. But if it is False, I want it to highlight.
=IF(...
0
votes
1
answer
52
views
Weird hidden character in Excel that counts up in COUNTIF
I have an Excel sheet which is automatically created by an export of a time scheduler system. I want to count some columns content (to filter out all rows with no content). But weird: some cells ...
0
votes
0
answers
75
views
VBA - change cell formatting based on another cell's format
How to change cell formatting based on another cell's format?
I tried the following code:
Range("A9:A9").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FormatConditions.Add ...
0
votes
1
answer
35
views
Can VBA be used to set print area as a formula in a sheet?
I am using VBA to create sheets from a template and then creating named ranges scoped for each sheet created. Each named range corresponds to the print area that would be a page when printed. I also ...
0
votes
1
answer
47
views
Excel Formula Combine MATCH , INDEX, COUNT
I have 2 sheets. the first one called 'Employee' the second 'Database'
In 'Employee' sheet in cell 'AO3' I want to bring the sum of comment ' Meet Expectation' how much declared for 'x' employee based ...
0
votes
3
answers
53
views
excel get sheet name from address
i am trying to get the full sheetname dynamically from the address with the below formula in another sheet. is there a better way ?
address : '[Airport - Daily Burn Rate_2024.05.08.xlsx]HQ 2024'!$A$1
...
-1
votes
1
answer
391
views
Excel: Lookup '1' and return multiple values
This seems rather simple be cannot currently find a solve for this.
I am currently in a spreadsheet, which has a column that is returning a binary value on the basis of random sampling.
I need to ...
0
votes
0
answers
41
views
Excel: Countif with multiple criteria
Sheets("Create Summary").Range("B3").Value2 = _
Excel.WorksheetFunction.CountIfs( _
wsSourceData.[P:P], "Airports", wsSourceData.[AQ:AQ], "Not completed&...