Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Formulas (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the General forum. See all tags in the site
  • Re: Formula for displaying a date only if another cell isn't empty

    Thank you Peter. It worked perfectly. Does the =68 mean date? Is there alist of what the formats are by number? Thanks, again, for your help. It's greatly appreciated.
    Posted to General (Forum) by fierhawk583 on Sun, Mar 8 2015
  • Formula for displaying a date only if another cell isn't empty

    Hello, I'm trying to use this formula =AND(NOT(ISBLANK($S2)),DATE(YEAR(S2)+1,MONTH(S2),DAY(S2))) to display a date one year from the date in cell S2, but only if cell S2 isn't blank. All I receive is True or False in the cell. Please help. Thank you. Firehawk583
    Posted to General (Forum) by fierhawk583 on Sat, Mar 7 2015
  • Add Missing Dates

    Hi all, I have different csv files which contain Dates and time steps in the first column in the following format: 27.02.2007 22:00 27.02.2007 23:00 28.02.2007 00:00 28.02.2007 01:00 28.02.2007 03:00 28.02.2007 05:00 As you can see the 04:00 hour as well as 02:00 hours are missing from the file. I will...
    Posted to General (Forum) by c123 on Mon, Feb 11 2013
  • Doing a bulk searching through data and print to comfirm it's there and saving the data to another sheet

    I hope no ones posted this on here before I was looking but was not sure what to look for? Here what I need to do, I trying to comfirm that certain product pictures are on a CSV sheet so I can run a Thumb Nail Generator to load load 4 different size pictures to the server. if they are not there it stops...
    Posted to General (Forum) by Don on Sun, Sep 16 2012
  • Values for #REF!

    I inherited an EXCEL sheet that has the following formula as a rule for the conditional formatting of a group of cells: =NOT(#REF!=3). I have tried to find what values #ref! can take on but have not been at all successful, Can anyone say what values #REF! can have and what they mean, of just what the...
    Posted to General (Forum) by AlexScianna on Tue, Feb 14 2012
  • changing number in column

    I have a column with numbers that all start with 7 and i want to change all of them to 8 ex 711256 712345 711666 can anyone give me an idea on doing this thanks in advance
    Posted to General (Forum) by rwbaker on Sat, Apr 23 2011
  • Re: How to create a game schedule

    There is a general approach to this for odd and even numbers of teams. I have a spreadsheet that does this and calculates schedules in a couple of different ways. However it is open office and may be a little different from Excel (see http://templates.services.openoffice.org/en/node/4035 ). There is...
    Posted to General (Forum) by Ian_T on Thu, Sep 9 2010
  • Need to generate a packing list from an order form

    Every week managers from arounfd my company send me a supply order using teh attached spreadsheet. THe main page of the sheet is setup to atuomatically calculate their order total and then we fill the order. I would like to generate a packing list to include with their order. I need the packing list...
    Posted to General (Forum) by Asher on Wed, Apr 28 2010
  • Combining Two Sets of Data

    Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
    Posted to General (Forum) by rebsbails on Wed, Oct 7 2009
  • How to create a game schedule

    I am not an expert at Excel (casual use for a few years making simple reports) but I've taken on a task of creating a spreadsheet showing the game schedule for teams in our club. This spreadsheet is a tab in a workbook that keeps track of scores and stats. I'll describe the best I can. We have...
    Posted to General (Forum) by Ross Armstrong on Mon, Aug 31 2009
Page 1 of 2 (14 items) 1 2 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.