Search results

Hi guys, Could anyone share any resources they have found useful or areas that look at excel performance and speed. A large part of my work requires building complex models, ran against often huge data sets. I've always struggled with creating models that crunch numbers on such huge data sets...

Thanks so much, works perfectly

I have been trying to calculate an exponential formula by have no idea how this works I know the exponential formula is something along the lines of y = exp(linest(ln)) * e ^ linest(ln) * x But I can't seem to get this to work (the yellow highlighted cells) - would appreciate if someone...

Hi, Wondering if someone could help me simplify this code, it is a basic validation that checks if the values in the first 10 columns match what I expect them to, I have come up with a fairly long winded approach, but hoping I could simplify it in a way that would make it easier to expand if I...

Say Row 1 Column 8 (A8) has the title "STARTING RANGE". Can I use VBA code to search Row 1 for the exact word "STARTING RANGE" and use that column number (8) as my Integer Variable ? If someone starts moving the spreadsheet around I don't want to have to manually change the code every time to...

Hello Not sure if this is a macro or formula based question But I'm having issue with check boxes that would appreciate some help with I'd like to create a todo list where all items that are checked will be moved to an archive worksheet (with the date it was completed). If possible, the two...

Hi I'm am trying to work out what the maximum "quality" (before the current one) that is the same product and has a price available. Quite confusing to explain so I've attached a sheet with a breakdown of what I'm trying to do, and my attempted formula which is failing miserably :( any help...

Wow ... I feel silly Thankyou so much for the help though !

Hi I have a spreadsheet that is quite dynamic, it generates reports that are split between 3 tables of which each can range between 5 rows to 2500 rows. I need to be able to define a point (or points) that can easily change. I have attached the spreadsheet as an example, I need to be able...

Thanks guys These are great, @YasserKhalil - your code is very quick but not that much different to Narayan's, wondering what it is that is making it run so much faster ???

The test macro already decides that if there are consecutive cells of the same number, it will delete the 1st one. Thanks

Hi, I need to learn how to create a simple loop of a macro, ive attached a sheet where there are two buttons that activate a macro, the first one creates a formula (it is just checking if the next cell is in ascending order) & the 2nd button deletes all those that have failed. I would like a...

This is awesome thanks !!

Hi, I am trying to figure out how to identify if a value is between the nearest 2 available values of the same criteria. I have attached a spreadsheet showing what I mean - and in the yellow a sort of "solver" on how the equation should work - can anyone help provide a formula that would...

Hi, I have attached a sheet which shows the desired output I am trying to create, I need to be able to quickly generate a table with 4 rows for each unique value in Column A (which are years) For every year available in the data tab, I need a row for each quarter, even if no data is present so...

I have this simple ol' code of line running first when you select one of my macros; Workbooks.Open Filename:="~C:\Desktop\afilehasnoname.xlsm" Problem is, if the file is already open - then it will either prompt to reopen the file (without saving changes) or end the sub if you ask it not to...

Thanks for your suggestions - Jindon, worked perfectly this is excellent - thankyou very much :):):):):):):):):):):):):):):):):):):):):):):):):):):):):)

Say on column A I have a list of dates, I would like to DIM the cell next to today's date as the range. So if A1 is 18/05/2016 then the defined range (lets call this TODAYRANGE) should be B1, but, if A2 is 19/05/2016 then the defined range tomorrow should be B2 ? Is this doable? Thanks JT

Thanks - this is brilliant. Wondering, with this line; Open ThisWorkbook.Path & "\archived prices today.csv" For Append As #F Is it possible modify this so you can select the filepath / filename ? Gracias JT

Ah yes of course - as attached

Yes a text file is fine - I won't likely need the old data anymore but just need a record of it. Re-attached file with my formula & 2nd tab for desired output. Understand the formula will need to be adjusted on the macro so that the range is defined from the first row to the last available...

Hi, I've attached a spreadsheet - it has a list items (in column A), their fee's and the time they were obtained. So the same item can be on there many times but on different dates. I need a macro that moves all the oldest prices into a separate spreadsheet (preferably .csv - called archived...

No yes thanks this works perfectly Thankyou

1. Just a two column range, my bad!! 2. Just the last cell in column B, regardless of whether or not column A has a value (although with this dataset, there will always be a value in column A) Thanks

Hi, Im sure this is quite a simple question that I need help on. Say I have a table with 2 columns (A & B) that is 1000 rows long - column A has values in every row up but column B only has values in some of the rows. I am trying to define the last row on column B (say it is row 8015) as a...