Recent content by JERD1074

I have a column in excel that has dates, i need to do 3 things to each cell in the column. 1) convert to txt by inserting a ' in front 2) if there are not 2 characters for the day and the month, add a 0 in front of each. 3) remove the /'s there needs to be 8 characters in each cell. ie...

this was perfect PHV! exactly what i needed. Thank you.

that is the expected result... what i have now, is just the TicketNum column and the System column. TicketNum System 15478 SAT 15494 SAT 15497 SAT 15521 ARC 15525 ARC would like to add the count per system column

I have a query that lists all of my tickets for each system. i would like to add a numerical field to this query that incrementally counts the number of tickets per system... ie. TicketNum SysCount System 15478 1 SAT 15494 2 SAT 15497...

F8

i have a spreadsheet that has a bunch of information on it. i would like to create several tabs that sort of filter the information by system. there are 10 system, so i created 10 spreadsheet tabs... i tried the vlookup formula to get specific system data, but it is only getting the first...

there are several threads that tell many different ways to do this. do a search for multiple attachments and you should turn up several pages. here is a good one to start with thread181-75403

hey guys :D I created a form in database that a user can select a start date and an end date, it stores these dates in a table. then the user can run whatever reports they want to. the dates are for their reports... pulling data between start date and end date. when there is only one user...

thanks guys. :D I ended up using anotherhiggins post. it works great. Thanks.

is there a way to have a formula look at a value to use as a reference? here is what i am trying to do. in sheet1, in a2: =Sheet2!D15 in a3: =Sheet2!D24 is it possible to have the row number be a cell reference? sort of like this... =Sheet2!D(I4) so i can change where the formula is looking...