sub array

New to VBA so please excuse my ignorance. I have a daily bank transactions spreadsheet that needs to be sorted in a specific way. First, the debits need to be at the top, followed by the credits. If the transaction is a debit, it will have a value in column E, otherwise it will be blank. Same...

Hi guys, This is my first post on this forum so sorry if it's not clear but I'm hoping for some help with a formula. I'm trying to design a formula that will present people with a list of holiday destinations based upon when they'd like to go. On the sheet 'Countries' there's data with each...

Hi everyone. I've been racking my brain with this one for a while now and am hoping someone can help me to understand what change I need to make to return unique values. I have a workbook with two worksheets. One worksheet contains a list of every employee in my local organization, and in the...

Hi. I have a table (PipelineTable) with these columns: P Amount I need to extract the top 5 amounts from the rows that meet a criteria: P is a fraction (between 0 and 1). For example, if this is the PipelineTable: <tbody> P Amount 0.5 25 0 50 0.75 45 1 12 0.5 20 0.75 25 0.25 8...

Hi All, i have an array arr(0)= 1 arr(1) = 2 arr(3) = 3 ... arr(n) = n and i would like to find a way so that when i write in in a cell it gets as: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14 15, .... each line will get up to 14 elements of the array with commas and then will...

Not entirely sure how to title what I need doing, so I hope the one I chose is alright. I'm fairly new to VBA, so I don't know much, and this is my first post here. OK, this is a bit complicated, so let me set up an example of what I'm dealing with before I go on to explain what I need in the...