=a1

I am looking to use a formula that counts data in another sheet in the same workbook but use a cell data info to get the right sheet. I have sheets named 2017, 2018, 2019, ect and need to have my countif formula in another cell to look for data in the correct sheet depending on the data in...

Hi, I came across this formula which works well, however I would like to be able to apply it to G18:G150 not just to C1. Also I would like to change the formula, =A1, to {=dependency} this new formula should increment as it is copied down. Dependency =...

I would like to create a duplicate of each cell in a column and be able to auto fill the pattern on out. Example: B1: =A1 B2: =A1 B3: =A2 B4: =A2 B5: =A3 B6: =A3 and on and on. I cant get the auto fill to continue on with the pattern. It just keeps repeating the existing cell and doesn't...

Hi, Let's say I have 10 in cell A1 and 11 in B1. If I put in the formulae "=A1<B1" into cell C1, I'll get a TRUE! I want to be able to make the symbol "<" a parameter such that I can put say (in C1): "=A1indirect(D1)B1" with the "<" inputted in D1 to still be able to maintain the formulae...

In C1, there is this formula "=A1+A9+A17+A25....." and the cell displays a big zero. I can see that A1 is 3240. So is A9, A17, A25, etc. In D1, I enter this formula "=A1" and the result is another zero. If I copy A1 and paste to E1, the result is 3240. If I enter "=E1" in F1, the result is 0...

Hi, I've got the date picker embedded in a cell giving the correct/current date (in A1) - all good. I want to export the date to another cell but when I do '=A1', it gives me a return of 00/01/1900 How can I get it to give me the date entered? Many thanks, Schall