Search results

HI, I am looking to set up a resource spreadsheet that contains a supply and demand function for HR. Looking for something that is not too complicated. Are there any good examples or templates out there?

Dan_I The files is in Google Docs link below: https://docs.google.com/#folders/folder.0.0B90dy-nGE_IUZWY5MzFjZmItZjQ3Yy00ODhiLTgzZDMtNjBkNjk4YmVhMmUy Happy to discuss

Dan_I I can share- how do I get this to you FAz

Hi, I have a table of figures that use the HLOOKUP function. The table starts on column C3 and continues to AE6. However, when I use the HLOOKUP I get #NA in the calculated cell. The formula that I am using is: =HLOOKUP(COUNT($C$3:$AE$3),$C$3:$AE$5,2,FALSE) Table of Data Weeks 1 2 3 4 5...

Thanks for this. I have tried it, and works, but would like this to be able to pick up the next value in the column, irrespective if the number is large or small - whhat would the formular look like, assuming the table was updated weekly. Data. Week 1 2 3 4 5...52 Value 20 10 3 4 5 ...

Okay not that clear, but effectively how do I get an excel table to look at a column of data and only pick data that is within the latest column, and not the previous column. A new column will be added with data every week. What kind of macro or formula do I need to apply? Faz

I have created a column that has 14 rows of text, the data associated with this column will chnage by adding a new column on a weekly basis. The intention is for specific cells from this column to be inputted into a second table, and in a specific cell, that will allow me to create create a...