All Questions
3
questions
0
votes
2
answers
583
views
Excel VBA-How to clear values of rows but keep formulas in a row when certain condition meets?
Lets say I have 10 groups of data sets.
I want to compare cell values of "E" and "G" for group 1 data set. If "E"cell value="G" cell value, I want to clear ...
- 5
2
votes
1
answer
113
views
Formula inside conditional sum (Excel)
I have a VBA function, that check cells and returns an integer. (for example CheckThis(A5) => 23 )
How can i do something like this:
=SUMIF(A1:E1,Checkthis(N) = 23)
I tried various possible methods ...
- 83
0
votes
1
answer
3k
views
Generate ordered numeric list in Excel based on cell value
I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...
- 115