home

Hi Everyone, Not sure if this is possible but I have a list of propertys I downloadd every day. there location is show in Longatude and latatude. I want to know how many are within a 5 mile radius of my Home. also in in Longitude and latitude. So the ideal solution would be two formulas. 1...

Hello, I need some help regarding formula-ing this. It goes something like this ! Hopefully i made sense, if not, let me know and i'll attempt to clarify it. Table 1 <tbody> Date Department Seconds Purchased etc etc 18 July 2018 Home 500 1 as fs 19 August 2018 Phone 100 2 asf sf 19...

Hi: This is just a FYI. Not really sure what happened. I have been using an Excel file that is stored in OneDrive. In that Excel file, I have a bunch of formulas that using vlookup. As soon as I update column A with a dropdown list item, column B, C and D is updated based on the value in...

Hi guys.. So I am not sure how this can be but into a formular so I can get the wanted result on the right above in the table. On the left side there are more numbers and Letters to the left but they are not consisted or hang on.. there are numbers like FT12345678 or TT12345678910 if the...

Hi Guys, I have a spreadsheet with lots of football scores, I have attached it so you know what I'm talking about. Here is one of the entries, <tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;"> Ref Output Home Away HTHome HTAway Date FTHome...

Hi VBA experts! I have a big data set that shows where individuals went on daily trips using addresses. One column contains the To address and one column contains the from address. Obviously if Row 1 says From Address A to Address B then you'd expect Row 2 to start with From Address B...

Good morning dear wizards. Can I please get some guidance on this dilemma? I want to run the code below ONLY on worksheets whose names DO NOT START with "ULT". Some tab names are all letters, numbers, or both letters and numbers. Is there a way to do that please? Sub UNprotect_All_Sheets()...

On my home computer, I'm running Windows 7 and Office 2010 and at work we have Windows 10 and Office 2013. I wrote a user form on my home computer that opens as soon as the workbook is opened. Here's the problem, while the userform is opened I'm still able to open other workbooks on my home...

Hello All, If I have a tab labeled "Home", how can I lock the tab so it will not be able to be deleted, with out simply hiding it? And, I still want to be able to work on the Home Worksheet, just not be able to delete it. Thanks excel 2013

I have a workbook with 20 different tabs. Is it possible to have the 'Home' tab always visible? For example, when I scroll across to find sheet 15, I am still able to see the Home Tab. The best way to describe it is to do the same as Freezing the First column in a sheet. The Home tab will be...

Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work:confused: <tbody> Away Home $50 TRUE Home Away Home $75 TRUE Away Away Home $100 TRUE Away...

Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work :confused: <tbody> Home Away $50 True Away Home Away $75 True Home Home Away $100 True Home...

Good day, I am a bit of a neophyte but can follow most times. Right now the issue...I have a home budget program that works on every computer I own also those at work, but it does not work on my laptop. The error message I keep getting is "Could not load an object because it is not available on...

I have been doing some calculations on the Vegas odds for the NBA Championship series. I'd like to calculate the odds for every possible combination of wins and losses for the rest of the playoffs. I'd like to set up a table something like this: <tbody> C/R C D E F G H I J 7 Game 3 Game 4...

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)? In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what...

Hi folks, I'm looking to buy a SurfaceBook 2 for home and working from home. My IT person at work said I'd need at least an i7 and 16MB of RAM. A SB2 with those options is *really* pricey. I'm wondering if I can get by with an i5 and 8MB. For background, I work with Excel files that are...

ok so my problem is that i currently have two rows of images, one for home kits and one for away kit images for a football database i entered. this being my current formula to pull the image dependent on the match that is requested by the user...

I have a macro for a workbook, I will post the beginning of the code below. We have a selection sheet (Home) What I need is for if cell G9 on Home says select, a message box to pop up and end, if G9 contains any other text, resume the macro below. Sub PWSub() If (Now() - Int(Now()) <...

Hello all I'm new here, and seem to stuck on some code, I have a sheet called home with my macro buttons, I also have a hidden sheets called datadump3, that I use to import data from another work book, that all works fine but I am having an issue with the last part were I am deleting rows that...

i have a workbook with 4 sheets 1st three are Jan, Feb, Mar and 4th one is home. Columns are style no., qty and unit price. i want to check index match the unit price of mentioned style number from all three sheets. Like i want a formula in HOME sheet in cell C2 which see style no. in cell A2...