kinds

I'm trying to figure out how to add 1 + 3 and then keep adding three to the sum? I am curious how to make that work, I've tried all kinds of formulas and now I just want to know to know. 1+3 = 4 then 4+3 = 7 I want to keep it running..

Hello All. I have the following Code: Sheets("NonFormat").Select With Selection Cells.Select Selection.ClearFormats Selection.Hyperlinks.Delete Application.CutCopyMode = False Range("Z1").Select Range("A1").Select End With This is working in place of pasting special...

All~ I am looking to write a formula that takes the data from u2:dr2, find the first reference to the number 70, search right to left, and then returns the corresponding date in u1:dr1. I have tried all kinds of things and just can't seem to get it correct. Do any of your brilliant minds have...

Hi - I have been using on a Query for a while where the date(in text) is 23/03/2012. Unfortunately a process has changed the date (in text) to 23/Jun/2018. Therefore when I use my Query Like "*06/2018" it brings nothing back I have tried all kinds of variations (trying to return all entries...

Hello Excel Guru, I'm working on a VBA and need to filter dates only. In the column, there are different kinds of data like dates, string, numbers and so on, but i only want to filter the dates (they are different but in the same format), can anyone advise how to do that? Thank you very much!

Hello, I was wondering how I could get a number from a cell, Lets say A1 = 3, and take another number, could range from 0 to 10, from D1 = 2, or something and take the value in A1 and turn it in .03 in cell C5, using VBA. D1 is going to set the number of decimal places including the value in A1...

Hello, I have the code below that works as intended (except the last condition matches with Bananas for simplicity). I need to change it so that in adition to existing criteria it counts all alarms starting with "Ban". So it would count all the alarms for "Bananas", "Bandanas", "Bankrupt" etc...