All Questions
75
questions
0
votes
0
answers
82
views
VBA Formula Instead of FormulaR1C1
Following code works as intended. However I am trying to avoid copying the formulas in each cell inside my FormulaArray using FormulaR1C1. It slows down my data collection in my other array. Because ...
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, ...
0
votes
0
answers
117
views
How to get Excel Sheetname on Android without using CELL function
I tried to get the sheetname using formula "=CELL("filename",A1)" which was successful on PC (Windows) but when I transferred the file to use on my mobile phone (Android), the ...
0
votes
0
answers
40
views
Indirect function usage
I am trying to use the indirect function to refer to a cell in another workbook:
A1 = 'C:\Users\thekv\OneDrive\Documents\accessmydocs\[KVR 4.0.xlsm]SheetOne'!$e$32
B1 = indirect(a1)
I get #REF!
Is ...
-1
votes
1
answer
120
views
Logical test in Excel based on the Value in the Two cell
I need Excel Expertise support to solve my Excel logic test issue.
I have code in two tables which update the value as 1 and 0 based on the availability, SO in a another table I am updating ...
0
votes
0
answers
69
views
How to Write Excel Function into Cell using a variable?
Thanks for taking a look.
I am using VBA to populate cells where other code programatically finds the last empty row and writes into the cells. I have this part working fine. The variable for the row ...
-1
votes
1
answer
43
views
Date calculation issue in excel
Could you please help me in below calculations?
Problems are highlighted in red colour in the snapshot below.
-1
votes
1
answer
198
views
Datedif issue - convert number of days to "--Years--Months--Days" format
I should convert number of days to "--Years--Months--Days" format. I am mostly calculating the percentages of working days.
=DATEDIF(B2,C2,"y")&" years "&DATEDIF(...
0
votes
1
answer
294
views
Issue with DATEDIF function
DATEDIF function giving different values as shown in the snapshot.
Why this?
2
votes
2
answers
332
views
Is it possible to filter horizontally?
Formula =LET(_x,XLOOKUP(G18,B1:P1,B2:P16),FILTER(HSTACK(A2:A16,_x),_x<>0)) works well with vertical filtering, is it possible to filter horizontally as highlighted in green color in the snapshot?...
1
vote
1
answer
165
views
I'm using concatenate function in excel but result is "true" and "false", why?
I'm trying to convert date and time to text but when I use this formula
=concatenate(text(A2,"yyyy-mm-dd")&" "&text(B2,"hh:mm:ss"))
the result is "true" ...
0
votes
1
answer
75
views
How can I apply Month function inside a criteria interval in the SUMIFS excel function?
I'm using excel to do budgeting and I have this situation:
I have a grid with expense categories as rows and months as columns and I write expenses in the right list, this is an example:
Using a ...
0
votes
0
answers
17
views
want a function that when a date is entered in the upper part it will show the data of that date and if no date is entered it will show the total data
I want it to read the data from the date, and in the upper part, if a manual date is entered, it will show the data of that date.
I put the date =Today() in the Report Day & time section and ...
0
votes
2
answers
60
views
Formula where it shows the cell location for certain words in the list but with blanks. - Excel
Is there a formula where if I have a list, for example, "Ready For Work" it will write down the cell location into 1 cell, but only if there is no one working on it (blank name) so that I ...
0
votes
1
answer
197
views
Excel: Combining SIN function array and RAND to add noise
As the title suggests, I would like to combine SIN function with RAND function so that it results in an imperfect SIN trend. As of right now I've got two functions:
SIN function:
=TRANSPOSE((SIN(...