I have a need for a user to select a group and a day (see attached sheet) and for the formula return the groups of letters on the right.
For example select Group 1 & Day 2 would return
TEAIM AAETN INATE EAINI EITNI MIETA etc
When I have a single criteria I would use a lookup (hlookup in this...
Thanks Luke, I was just working on a sample data book to make things a bit easier to understand and came about a solution from a colleague.
he suggested a logical test to check the date and return a n/a if that date had not passed. Attached (hopefully) is our attempt. The cell references have...
I have a small problem with some data and a chart for project management data. It goes a bit like this.
I have 2 sets of data. Planned spends (based on people and hours) and actual spends (again people and hours). The planned is for a full year and the actual is updated weekly based on...
No problem, I think I may have stated on the right way. this is the rough idea so far.
A1:A13 used for web query to get data and paste in into column. Refreshed daily
Text to column done manually - could be automated with a macro - to extract data from text and place into B1, C1, D1 etc...
I've a question that is out of my league.
I would like to extract the data from a text file that is updated daily. Then append the data to a column (or row) to build up a data set over time. The information is held here (http://www.swpc.noaa.gov/ftpdir/latest/wwv.txt) and in the format below...
Thats brilliant Narayan. Thank you for your help. I'll have to check it out on a machine with 2007 on it the one I'm on today only has 2003 and the formula falls over as is.
I'll be needing this in the future as well
Thanks again
Alex
Narayan,
Thanks for you help, its always hard to try and explain these things so I really appreciate this
1. The output is what I'm after.
2. A through E have other data which isn't relevant to summary. As an explanantion it is a scoring mechanism to see if a project is ready to be...
Hopefully this should help narayan.
http://db.tt/WbWJ5mqb
There are quite a few questions that are asked, some will have answers and some will be blank. Hope it makes sense
Alex
I'm using excel 2003 and am building up a 'Readiness check list'. Part of the structure has a column for 'Actions', one for 'Person Responsible' and one for 'Due date'. I would like to summarise the actions (along with other information) on a summary worksheet. Can I summarise this information...
So here's version 1 (http://cid-d92f4fd067efe995.office.live.com/browse.aspx/.Public)
I've put a very short instruction sheet on one worksheet
Any comments?
Thanks again for the advice. The sheet that I am building is starting to take shape. I'm using the SMF add-in to get data from a couple of different sources (MSN and Yahoo) to build up the screener.
Itcertainly isn't pretty and probably not very efficient. Once its been built I would really...