Skip to main content
58 questions from the last 30 days
Newest Active Bountied Unanswered
Advice
1 vote
15 replies
142 views

I have a huge table with over 2000 rows with text. Some rows begin with letters and rows that begin with numbers. I now need all the rows that begin with letters to cut and past them after the last ...
Roger20's user avatar
  • 21
0 votes
3 answers
198 views

I have a list like the one shown below: Owner Alone? Mickey Yes Goofy Yes Pluto Yes Pluto / Mickey No Minnie Yes Daffy Yes Minnie / Goofy No Donald Yes In Excel, how can I make it that each name has ...
user30082921's user avatar
  • 35
1 vote
4 answers
149 views

I'm trying to create a simple macro, and the solution is eluding me. Let's say I have a table: Header1 Header2 AAA 100 BBB 200 BBB 150 BBB 250 CCC 300 CCC 200 I want the formula to calculate so that ...
Collin Michels's user avatar
  • 21
4 votes
2 answers
112 views

I'd like to concatenate values from all columns of a table and store the concatenated result in a new column. Yet, as far as I can see, I can only run a single expression in an `each` function body. ...
AxD's user avatar
  • 3,324
Best practices
1 vote
5 replies
210 views

I need to import the currency exchange rate table to Excel from the web (here's the link to the website https://vrbank.com.vn/ru/exchange-rate/) and update it on a daily basis. I've tried to use Power ...
Night_Guardian_0910's user avatar
  • 11
2 votes
1 answer
141 views

I'm trying to get a button that establishes a macro for other buttons, but not itself. So far, what I've got is VBA that does successfully change the macro for buttons, but it ignores range parameters ...
Ryan K.'s user avatar
  • 33
1 vote
2 answers
157 views

I have cells with a sentence in each (text without line breaks). Now, when an existing Userform is opened, I would like each word of the text in the cell (in the last row) to be listed in a Combobox-...
Roger20's user avatar
  • 21
-3 votes
2 answers
119 views

I am keeping track of my daily spendings using MS Excel. The columns are Date (MM-DD-YYYY), Day of Week (i.e. "Monday", "Tuesday", etc.), and Amount ($). I am trying to figure out ...
Phantom's user avatar
  • 3
2 votes
1 answer
105 views

I am trying to change all of the Conditional Formatting Rules formulas in an excel file that will change the column references to a new inserted column. I have tried the code below and it does run. ...
AJAX's user avatar
  • 39
1 vote
2 answers
178 views

I'm using VBA to import the table from Federal Fund Rates into Excel. So far I've got: Set HTMLDoc = CreateObject("HTMLFILE") HTMLDoc.body.innerHTML = objHTTP.responseText� ������������������...
Night_Guardian_0910's user avatar
  • 11
Advice
0 votes
3 replies
151 views

I have one worksheet with a few columns: Product name part name order of part in product Volume A Volume B Difference vol A and B Dif % One part can be used for many products. All products are ...
Hubert S's user avatar
  • 77
Advice
2 votes
3 replies
106 views

Suppose I have irregular dates in column A, cashflows in columns B and let's say an 8% rate. I am trying to produce a formula to calculate the future value of these cashflows, taking into account the ...
MN Beitelmal's user avatar
  • 165
0 votes
2 answers
178 views

Here is a tiny sample from my Outlook summary, that actually has 941 incoming emails from 50 people (names, etc., changed to protect the guilty!). From Subject Received Size Veronica Topic A 15/10/...
RobinClay's user avatar
  • 21
2 votes
3 answers
130 views

I have an excel sheet with a bunch of vehicles in a column, and I want to populate a new column with the "type" of vehicle. Here's a quick screenshot. Or to save you a click it's like this: ...
InstantCoffee's user avatar
  • 21
3 votes
1 answer
122 views

I have a spreadsheet setup, where I loop through each row of the sheet, gathering a cell's data, combining it with a few other cells on other sheets to create a file path, and then copying the file/...
Metal's user avatar
  • 45

15 30 50 per page
1
2 3 4