Search results for query: *

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...

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...

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...

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...

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...