All Questions
3,347
questions
0
votes
2
answers
77
views
Extract the number and increment the value using formulae
I am trying to compare the cell value and extract some number from it and increment that number. While as shown in figure, I want to increment 0 to 1, this formulae works.
=IF(AND(A1 >= "00&...
0
votes
0
answers
78
views
Excel Macro to show applied formulas as Text
I want to loop through all columns and check the row 2 which has the data to check if there are any columns with references to other cells or if there are any formulas in them. So, if there is no ...
0
votes
0
answers
64
views
IF Formula to multiply different criteria by different values
I need to write an IF formula so that anything less than 100 is multiplied by 7, and anything 100 and over is multiplied by 1.
I have tried the following formulas:
=G2*IF(G2>1,7,IF(G2>99,1))
=...
-1
votes
1
answer
58
views
Convert Complex Table to Simple Table
I have the below table:
I need my table to be formatted in either Excel or PowerBi to look like the below:
Basically, I need the date to become a column.
I am unsure where to start with this. Please ...
-1
votes
1
answer
56
views
DAX Calculation With Multiple Parameters
I am trying to calculate a daily net balance based on 4 fields.
1.) Balance from Previous Day
2.) Net Invoice Amount Current Day
3.) Payments on Current Day
4.) Adjustments Made Current Day.
In excel ...
0
votes
1
answer
277
views
How to apply/change color to partial text in a cell from the resultant excel formula in VBA?
I have this statement in excel cell B12 which is actually the resultant value of a very complex excel formula:
"● Up to January 23, 2024 - The national mean monthly temperature was 10.12 °C, ...
1
vote
2
answers
51
views
Copy a formula in Excel from one worksheet to another and have worksheet name in formula update
I have an Excel workbook with each months accounting sheet tabs, Jan > Dec. In opening debits, I have a formula:
=IF(JAN!D31>0,JAN!D31,JAN!-D31)
which says, if D31 is greater than zero, then ...
0
votes
1
answer
63
views
conditional formatting after selecting a cell from list
I want row of a table to get color after selecting a number in a cell of that row from list
I want row to have red color when we select 1 and blue color when we select 2 form dropdown list
thanks
...
0
votes
0
answers
31
views
What is a way I can copy over only cells that respond to a certain criteria (a string on both sides) to a different sheet in Excel?
I have a list of trades. They have their own info, etc. I want each trade to show up in its own sheet for data purposes with some kind of formula. Say I have 12 products, my entire list of trades ...
0
votes
0
answers
27
views
Conditional Format Date From Date In Another Cell
I have three date columns, Manufacture Date (B2), Inspection Date (C2), Future Inspection Date (D2), the Future Inspection Date column looks at columns B2 & C2 to determine the latest date from ...
0
votes
0
answers
51
views
Make auto fill form a part of table
I have a table (table1) then is my data table same as below
Table1
and I have a form then that have a table inside it same as below
Form
I need when I enter the "POD" from "Table1" ...
0
votes
0
answers
67
views
Dynamic array with VBA - Excel [duplicate]
I m using VBA code to import below formula to specific cell:
.Range("AA9").Formula = "=SORT(UNIQUE(FILTER(tblClients[Clients],ISNUMBER(SEARCH($C$2,tblClients[Clients])),""Not ...
0
votes
4
answers
130
views
Looking up Excel values based on sheets and rows
I was wondering if it's possible to look up values based on sheet names and certain columns inside those sheets? I was trying to wrap my head around that idea, but couldn't actually find a solution, ...
0
votes
2
answers
159
views
Excel 2007: AVERAGEIF, SUMIF, COUNTIF, MAXIF, MINIF across multiple sheets, multple rows
@MGonet - I am very much appreciative for the answer you gave, and also the idea to use /COUNT as an alternative denominator (which I have decided to do). I have run into two different problems, ...
-2
votes
4
answers
248
views
How to convert text string (d h m s) to time format in excel
I have a column of data with the below format and need to convert it to a time format by hours to use in calculations and filtering like hh:mm for the first entry, no need for seconds
1d 8h 8m 23sm, ...