free

I have a dropdown list in excel. is there anyway that when i select a value from dropdown list cursor should automatic go 1 cell down automatically. (actually i m using this file in android phone. i want a macro free solution). i want that when i tap on a value in dropdown it should put that...

Hi Everyone, i have a shhet and down column f we choose between 3 words "Sold", "lost" and "free" All i want is a formula to tell me which of those three words has been used the most so count number of "Sold", "lost" and "free" and if "free" is the highest give me the word "Free" etc. please...

Hello I have a spreadsheet and would like an IF statement (if possible) that allows the user to enter free text if the IF statement is false. So I need it to say If E4=Mobile Shredder and H4=PS then select from drop down list. If not, then enter free text. Any ideas? Is it possible...

Hi, Does anyone know how to solve this. I have a lot of cells with free text in and I want excel to list every unique word and how often that word appears

Can anyone suggest a site for free downloads of historical Forex data into Excel? A year or two ago I got it from Oanda.com, but they now charge, and the code I found on the web to download their data doesn't work, even for the amount of data they provide for free. Thanks in advance

Hello all, i need some help with a formula. In column B i'll enter a value, depending on that value, column D will give me a rate, either "Free, B, C, D or E" So what i want the formula to say is: If B11 is less than or equal to B9 then "Free". If B11 is between D9 and E9 then "B Rate"...

Hi all Can anyone recommend Excel Tests that are online (preferably free) for beginners and intermediate. Part of a job I am recruiting for, requires a certain amount of Excel Knowledge, I am ok, but not great. So need some assessment tool, that will give me results to go along with their CV...

Hello everybody. I've the following job. https://www.dropbox.com/s/ek5nyx5lnfxclog/Develop.xlsm?dl=0 In the sheet "Beta" you can find the data source (column D). In the sheet "Alpha", in the first free column, I've to count the quantity of recurrence. Now, I've identified the first free...

I am sure this is easy for most of you, but I am struggling. I would like to put 2 IF Functions in one cell. I started with this and it works fine: =IF(A12="X",1,0) I would just like to add that IF B12 has an X, then it would equal 1 as well. Either A12 or B12 will have an X, never both...

Hi! I am looking for help with formulas in my macro enabled form, which will allow the user to add multiple rows to enter free text under 3 headings (if they require more than 1 entry). I want to have an "Add Another" button which the user can click to copy more rows into the form automatically...

link that downloads excel VBA for free

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...

From where I get free Excel Training from Beginner to Advance level.

Hi I want to learn how to import data from Access into Excel. I want to practice that. Where can I find free Access database to download so I can practice that? thank you.

Hi there, I'm new to using Macros within excel and I'm trying to write one that grabs data from 11 columns with a varying number of rows and appends it to the new free row in another table. I know this should be relatively easy, but as I said I'm new to this. Any help would be greatly appreciated

I was trying to reposition the Watch window so I cold see it and the Immediate window at the same time. I guess I must have moved it too close to something, because it jumped onto the the main code window. I was able to get it free using Tools | Options | Docking, but now it has latched onto the...

Hello, I am using the sub below to send out a single sheet to a new workbook on our network drive, in effect making a "back-up" copy for auditors to review. It works great but I always get the pop-up asking me if I want to make it macro free or enabled. Ideally it would be macro free, but I...

Hi, I have a basic 'action tracker' spreadsheet with the following columns: 1. Action Number (Unique ID) 2. Issue (Free text) 3. Action Required (Free text) 4. Target Date for Completion (Date Field) 5. Category (Drop down list - but effectively free text) 6. Risk Rating (Drop down list - but...

I know this is an Excel forum but I don't where else to turn. My computer is running rather slow, does anyone know of any free software that is virus free that will help speed up my computer performance. My excel files are taking forever to load and I don't have any programs open other than one...