290,069 questions
0
votes
0
answers
24
views
How to get the exact Team Name using Application.VLookup
Sheet1
Error during initialize:
What should be fixed in the code below to get the exact team name populated in the Me.cmbTeam.Value (combobox) if team member is matching in column 2.
Private Sub ...
- 749
0
votes
0
answers
13
views
Excel XY scatter chart glitch
Sometimes Excel refuses point blank to create XY scatter plots properly. Defaulting to a silly format plotting rows as lines with legends "series 1", "series 2" & "series ...
- 2,887
0
votes
0
answers
19
views
How to get the properties of Bundle Segment in CATIA V5 Electrical workbench using VBA?
How to get the properties from the Bundle Segment.
Below points are there in property window.
Type: Bundle Segment.
Reference designator: BNS0001.
Diameter: 6.2mm.
Bend Radius: 37.2mm.
Length: 238....
5
votes
4
answers
56
views
COUNTIFS from UNIQUE VSTACK
I have a table that I want to count how many occurrences of values in 2 columns there are, based on the value of a third, and for ease of readability, I want to be able to see those unique values with ...
- 2,595
-1
votes
1
answer
40
views
How can I use Excel VLOOKUP function based on specific text and not displaying all columns [duplicate]
How can I use VLOOKUP to display data from Sheet A to Sheet B based on one specific value in Sheet A cell D5. The specific value will be also located in Sheet B Cell A1.
I have tried using something ...
- 27
0
votes
1
answer
37
views
Calculated field in Pivot table using min of date
I have a pivot table that returns the min of a date per category . Can I have a calculated field that works like this: date - Today
I tried a calculated field but couldn't select the min of date to ...
0
votes
1
answer
41
views
How to compare data in each table row with rows in another table to find the best, non-exact matches
I have one table that is a list of parts that are going to be unavailable and I want to find replacements for each one of the parts. I made another table of potential replacement parts that I want to ...
- 1
2
votes
2
answers
65
views
Is it possible to construct an array in excel using existing cell values
It is possible to construct an array in excel as follows: ={1,2;3,4}
Using this method I want to calculate the inverse of a 5 x 5 matrix of a series of elements in one row rather than distributed as ...
- 63
0
votes
3
answers
92
views
Trouble at adding new sheet
Having trouble with the following code. It finds the sheet named "Out", deletes it if present, and recreates it by adding a new empty sheet and renaming it to "Out". The issue is ...
- 1,625
-1
votes
1
answer
51
views
Looking for empty cells in exel from end to top
I looking for a way to find empty cells in for example A1:A6 from bottom to start and replace them with first none-empty value above them. i want to use it with filter function to show the result in ...
0
votes
1
answer
53
views
How to simply match two cells that have a letter different, for compliance checking
This seems like such an easy solve, but Im just brain blanking on it.
Apologies on the picture, people say enter these things as an excel sheet and I don't see that option.
Currently my =MATCH(A1291,...
- 35
0
votes
2
answers
76
views
VBA For Loop to Create Data, Save to Array, and Display array on Worksheet
I am going slightly crazy on this and I'm not sure if it's because I'm searching for something that isn't possible or I'm just not searching in the right places! I am trying to use a for loop to ...
- 35
2
votes
3
answers
71
views
How to duplicate row and insert below based on cell value
How do I use excel VBA to insert a duplicate row below row 1? For example, A1 contains the cell value that corresponds to the number of rows to be duplicated below row 1. If A1 contained a value of 2,...
- 21
2
votes
0
answers
65
views
Issue with Copy/Paste from Word to Excel
I have some code to open a PDF file using Word, and then copy all the text and paste it into Excel for data mining. A good portion of the time, a portion of the text will not get pasted (it varies ...
- 21
0
votes
1
answer
43
views
What’s the correct format for a calculated time value on a userform?
I have a userform that takes my workday start time, end time, and two break times, then feeds them to cells on the spreadsheet. I can use those cells to calculate the total hours of my workday, but ...
- 101