All Questions
Tagged with worksheet-function vba
575
questions
0
votes
1
answer
753
views
Remove formula in cell using vba
I have made two vba codes.
For doing round off on selected cell. Working fine
For undoing round off on selected cells. This has a little issue. After i do this it make the cells isformula true. But ...
0
votes
0
answers
39
views
How to add a cell automatically to a sheet when I add another cell on another sheet?
I have some time series data, so I will add one new data point to one excel sheet for several sheets in an excel file, then I also need to add all these new data point to another sheet, so that I can ...
1
vote
0
answers
12
views
How can I generate a multi column sorted list in Excel based on data pasted into another sheet?
Okay, so I can't unfortunately go into too much detail due to the sensitive nature of the data, but the short of it is that I've got a table I paste into "Source" that I'd like to have two ...
0
votes
1
answer
142
views
Combine cells value with the header and ignore the blanks
I want to combine the fixed row value with diffrent column value but by skipping blank cells. I've a code but it is not working. Please suggest
Public Function SuperJoin(r1 As Range, r2 As Range, ...
0
votes
1
answer
27
views
Formula won't calculate or increment
In the following code, my formula apply as text and won't calculate. Also, Autofill won't increment cell number. I also tried with ActiveCell.Value
Dim RowCount As Variant
Dim VRowStartNoMember As ...
0
votes
1
answer
436
views
Excel VBA How do I set active cell to be only a cell with X data?
Dim NA As String
NAFinder = 9
NA = ActiveSheet.Range("F9").Select
For i = 0 To NARows
NA = ActiveCell.Offset(i, 0).Value
If NA = &...
1
vote
1
answer
3k
views
Delete Specific Rows from Excel from a List of Row Numbers
I have a worksheet with 83,188 rows and 4 columns of data.
I have another worksheet that has a list of row numbers (eg 18751, 9127, 696, and etc) that signify the rows I would like to delete from the ...
0
votes
1
answer
386
views
Is there a formula in excel or VBA to count groups of values? For instance if I had a column with the an "X" in groups of 1, 2, 3 or 4
IF column B, 8 rows had xx xxx xx xxxx xx xxxx xx xxx. I need to find how many groups of two X, three x and four x. The result of the above would be xx = 4, xxx = 2 and 4 = 2. I've tried VBA but the ...
1
vote
3
answers
3k
views
In Excel, how do I access cells using fully-qualified numeric coordinates (worksheet, column, row)?
I have the indices of a cell in an Excel workbook: Worksheet, column, row (and yes, I know that Excel likes 1-based indices.)
Given those, what formua should I write to obtain the value of that cell?
0
votes
1
answer
131
views
Create latest update date excel
I want to insert a last updated on () if any value in that row was changed. I have a column for this in my spreadsheet. Applies only with actual values changed
1
vote
1
answer
831
views
Find Closest Match (Conditional Lookup)
I am trying to do conditional lookup in Excel (MacOS). Let's say I have the table shown below, and I want to search for (type=alpha, length=165). In the table, there isn't an exact match so I'm trying ...
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
0
votes
1
answer
124
views
Max or Min of Consecutive Same Condition Match Excel or VBA
Max or Min For Consecutive Matching Condition
Dear Folks,
I am seeking help for the following roadblock in excel.
I am looking for a solution to find max/min if the conditions match for consecutive ...
0
votes
1
answer
382
views
Extracting all matching (or close to) values between given START n-th and END n-th values / using Power Query
Consider having two tables. Table1(T1) has Date/Time and Pressure value columns and Table2(T2) has also Date/Time and Info values columns.
T1 is showing pressure change through time, for instance: 21....
0
votes
0
answers
267
views
Can Excel only display the results from a FILTER, ISNUMBER, SEARCH formula and not the entire array of searched data?
I am creating a spreadsheet that can search an entire "Control" data table using two search boxes.
Search TextBox1 searches by UPI
Search TextBox2 searches by Zip
The two search boxes are ...