Search results for query: *

Hello all, I have an Excel problem that I need help with. Imagine a Fantasy Football Draft using Excel. You have a column of player names and a column for the "Pick Number" or the number that the player got chosen. 1 Adrian Peterson 2 Le'Veon Bell 4 Jamaal Charles 3 Eddie Lacy How could I...

Hi All and Happy Holidaze, I'm stumped. I am using a date serial formula to get current year, prior month GP%. Some of my sales and cogs have 0.00 and Access gives me the old division by zero error. I cannot figure out how/where to insert an iif statement so the query runs. Here is what my...

I am not quite sure if this can be done, but here goes. I have two columns F and G that I use to compare cell data. Example formula in Column F =B1=D1. Column G would have formula =C1=E1. In column A I am trying to figure out a formula to do display the words "ADD", "Update" or "Do Nothing"...

Hi all, If I try to load a csv file and it contains a number like 1E123 excel treats it as scientific notation. Is it possible to change Excel's default cell format "Text" instead of "General"? TIA TommyP

Hi All. I cannot figure this one out and was wondering if anyone knows if this is possible. Scenario: Multiple vendors with many materials in a table. Vendor Material 1 A 1 B 1 C 2 X 2 Y 3 Z Is it possible to export vendor ones materials to...

Hi All. I am on a quest to fing out how to transfer files with a BESFR41 and Yahoo Messenger. No matter where I look on the internet I cannot find the port# that Yahoo uses for this. Or is there a different setting I should be looking at? Tommy P

Hello, I am stuck on this and cannot find the answer within the archives. I use a between dates call within a query. Access has developed a nasty habit of asking the users to enter their date sets twice before returning the results. Does anyone know how to fix this? I have deleted the...

Hello, I was wondering if it is possible for a macro to be able to insert a row after so many (user defined) rows? Say every fifth row I want to insert a blank row. Or every second row etc. Second Question: Is it possible for a macro to delete the contents of every fifth cell or five cells in...

Hi all, I am using Excel 97 and have a need to delete random rows. Let me explain... I would like to present the user with an input box so they can select the number of rows to delete. Then delete those rows, skip one row, delete that same number of rows and skip a row, etc... I cannot get...

Excel 97 is limited to 65536 rows. Is there a way to make this endless? (assuming the pc's RAM would be the limiting factor here). Or is there another product available that will do this? TIA