I'm using a macro just to suffle a sequence of numbers and then assign that to a button (attached), as follow:
numm = Range("A1:A100")
ct = UBound(numm, 2)
lt = UBound(numm, 1)
ReDim dex(1 To lt * ct)
n = 0
For h = 1 To...
I think this is a big ask, but here goes!
I have an excel sheet which is refreshing and pulling data from a googlesheet. What I am wanting to do is when a refresh occurs any new line will trigger an email.
The data coming in will include an email address (Column J) I would also like to...
I need a formula to help the text below...
Company Name (D-0003504825)
to look like this
On my excel worksheet, all text inside parentheses include "D" then "-" then 10 numbers.
Good Evening Could someone assist. I am attempting to save a current sheet (Active sheet) into a new workbook and include in the Name the reference to Range B2 which is Start & C2, which is the user input date. Also would like to include B3, which is the End & C3 which is the user input end...
I have a formula they I need to adapt so that is "H" is within the range of cells, it does not include this within the count.
Can anyone help. please.
=SUMPRODUCT(('Agency Input'!D3:EV3=TODAY())*('Agency Input'!D4:EV26<>""))
I recently lost a bunch of macros to a PERSONAL file saved in the binary extension format (users caution/beware!) and am having to rebuild several macros.
I am running into a method range of object global failed error including the following lines of code. The macro to which these...
I'm using the following formula for working out Students who are above target and it works great.
=COUNTIFS($T:$T,">0",G:G,"RE Class 1")/D13
I want to also add to that formula (but I can't get it to work) to only include students "column H:H" with an attendance greater than "95%"...
I use a xls sheet as a help for keeping track of website user login and pwd's.
I know this isn't really best practice, but up to now it's still my most convenient solution.
Pwd's aren't conveyed in full, but represent a 'hint' that is obvious to me to help reconstruct the pwd as...
I need help!
I need help with a formula (in column D) to help me determine 2 categories: Right / Wrong
If my customer name in column A contains the word "Apple" (could be variations of name, And if the country (column B) does not include "Ireland" and if the products (column C) includes "Pen"...
Is there any way to include an image in a posting?
I know that I can upload the image to a file-sharing website and enter its URL in the posting.
I would prefer that the image appear within the posting when the webpage is rendered, without the reader having to click on the URL.
I have a table and want to include the 2 rows above the table (with titles, etc.) in my print area using VBA.
I've tried quite a few variations using OFFSET, with no luck.
Any help would be appreciated.
Currently I have the following formula which works great:
If I then wanted to include other candidates for large, with different text values than "EQUITY", all in column Z, how would I expand the above to include these?.
Hi I hope someone can help
I have a spreadsheet that draws data from other sheets through a power query.
1)How do I autofit row height each time the query runs?
2) can I include data on the top of the source sheet above the data table and not have it included in the final query...
I've often used the following two lines of VBA to name column ranges based on text labels in the first row of a worksheet, and this has always been really useful when manipulating data.
Set rangeToName = Worksheets("Sheet1").Range("A:BZ")
I'm struggling with how to write a formula that sorts by individual accounts and dates to calculate drawdown. Any help would be greatly appreciated! I was calculating drawdown by this formula =$A$2:A2/MAX($A$2:A2)-1 but that does not include date and it really needs to be in order. I'm not even...