I have a spreadsheet that needs a little tweaking. By little I mean I have 6 issues that I would like resolved. These are not going to be easy. I have tried to google for the answer but I have had no luck. I hope you can help!
Problem 1: I need the data from a row in one table to be temporarily linked to another row in another table in another tab. This will be dynamic and the linked row within the table will also vary daily. There are 10 total rows in each table. There are 5 different tables. There are 5 tabs. each tab has a table containing 10 rows. I hope that was clear enough.
Problem 2: I have a formula. In one part of the formula there is a cell count of a column minus the first entry of that column. Later in the formula, there is a cell count of a column but will a total cell count.
My problem is, I have to update this number every time I add a row to the column in question. I would like, if at all possible, this formula to be dynamic and change without my intervention.
39 freelances font une offre moyenne de 113 $ pour ce travail
Dear esteemed client, I am a proficient EXCEL and statistical analysis writer. I am par excellence in descriptive, Inferential, predictive, prescriptive and exploratory data analysis. As a qualitative and quantitativ Plus
Hello, I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in Data Processing and Excel . I have successfully collaborated with academic and industry partners and delive Plus
Hello there i will make all of them system auto also i will show you some samples regards ILYAS