Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gnanas

  1. gnanas

    Code Problem

    Hi, Date field called "Notifiedtime" gives date and time I wish to format this field to give me year and month only (200501 for january 2005) How can I format the field Any help would be very much appreciated Regards
  2. gnanas

    Excel Graph

    Iam trying to add atrendline to project future maintenance cost. On one of the graphs the exponential trend field is not highlighted Is there any particular reason for it
  3. gnanas

    MSQUERY CODE

    Where can I get a list of codes such as TRUNC, DISTN to be used in MsQuery for both formatting and calculations
  4. gnanas

    Thread List

    Could someone please explains how I could brouse the thread list and refresh my knowledge. At times experts advise others to look at a particular thread. How could I access that particular thread Regards Siva
  5. gnanas

    Changing Graph Colours

    Hi klmorgan Thanks for your help Gnanas
  6. gnanas

    Changing Graph Colours

    Hi,I get random colours whenever I generate graphs in Excel. Is there any way I can predetermine the colour of the graph. At times the colour is so bad for any printout Gnanas
  7. gnanas

    Range define

    Hi, I tried to use Insert>Name>Define to name a moving data range incoporating "OFFSET" function. I had no difficulties in creating the range name. However subsequently when I tried to edit the "refers" field in the range name I could not do it. The movement of arrow keys...
  8. gnanas

    date conversion to text

    Hi PeterMoran, Your second formula worked very well Thank you very much Gnanas
  9. gnanas

    date conversion to text

    I regularly import information from a maintenance database into Xcel for analysis. of teh database one column consists of date in dd/mm/yyyy hh:mm format. I then need to convert this column to yyyymm format. But I want this column to appear as text or number (e.g 200306). Even though cells...
  10. gnanas

    Pivot table sorting data

    I have a x-cel table like this work order mmyyyy expenditure 101 200201 150.00 102 200201 165.00 103 200202 185.00 for every mmyyyy we have many work orders with different expenditures. I need to find out the number of workorders in each...
  11. gnanas

    Automatic Formatting

    Thanks Guys I have learned little more on functions Gnanas
  12. gnanas

    Vlookup formula help required

    Hi Fneily & Sfvb Thanks for your prompt reply It worked Gnanas
  13. gnanas

    Vlookup formula help required

    I have two X-cel tables, using Vlookup formula I try to extract information from first table into the second one for comparison and totalling up . In certain cells I get #N/A because values are not available which is perfectly correct. However I am unable to sum up the column becaues of #N/A...
  14. gnanas

    XL97: "Subtotal If" array formula - Formula guru needed! :-)

    You could easily use Pivot table to find the subtotals
  15. gnanas

    Acsess error message

    Tks for all the advise. I have passed your information to our IT personnel for investigation and iron out the bug Gnanas
See more

Part and Inventory Search

Back
Top