I have a user that the formula is H3=G3/F3 - where both g3 and f3 are blank b/c they are not populated. The user wants them there so when the field would be...

Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How...

Is there a function (or an addin with this function) that just defines wethera character is present in a string or not ? ("Find" gives an error-string if the...

I have buttons that are hyperlinked to video and graphics. After pressing a button I get 2 warning messages about hyperlink security. can I turn these...

Column A Column B Column C R 2 NAAI C 4 H M ...

I have cells BA16:BH16 calculating value based on certain criteria, it all calculates correctly, I want to get an error message if more than one of these...

Excel; from a named range table of teams by division (BU10, BU12, GU10...) and their standings, I want to place the value of a particular team name in a...

HI, I have a file with names of the students for several years. Each studne thas multiple start and end dates. I want to create a macro which will only create...

What can be the shortest formula for this? If any 3 of 5 non adjacent cells have 0 then 0. Thanks

I need a macro that will 1.) Open Internet Explorer 2.) Go to a web page 3.) select a file for the previous day 4.) Save that file to my computer I have been...

I need to verify information from a data dump and would like to select say every 200th record from a Data sheet into a testing sheet. Is there a way to get...

I currently use a worksheet for my type of business (engineering) that I need to place a key to update each day. I do a daily report that calculates...

What I would like to do is the following: Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example,...

hi i want to 'make' a bar graph which is based on a table which uses the time format instead of whole figures. i have a set of times (12.00 to 14.00, or...

I have a spreadsheet with a list of customers including a column for id, name, address, city, state, and phone number. I would like to have a macro that...

I have a worksheet with a list of names and in / out columns. I am trying to sort the list of names by who is in or out (1 or 0). The problem I am having...

Here is a sample of the data. Condition 1 Condition 2 Condition 3 Type Problem A Type A Problem B ...

I have previously used the "choose" function for sum functions that would sum a data range for a month-to-date display. Recently we have found that one of...

I am trying to pull the information from the cell at the intersection between a particular row and column. The identifier for which row and column needs to...

Hi, I have 2 columns which process days it takes to finalise projects. The 1st column display the days and the 2nd column display how many projects were done...