hard

Images are below. Three tabs: 1) Report, 2) Store Vol, 3) Community Days. J53 on Report is where the return value will be. Currently, in that cell is a combination of a VLookup and an HLookup. The Vlookup is pointing to A53 where a 1 is located to indicate Store #1 . It then finds Store #1 in...

Hi all I am trying to build a spreadsheet to determine the cost of building a bespoke PC. Column A of Sheet 1 has the schedule of the types of components that need to be present, motherboard, hard drive, memory, etc. Sheet 2 has the individual components, Column A details the type of...

Hi Guys I have written a code to get directly from the Excel file in a login on a web page. This works well. However, I dont want my password to be hard coded in the VBA code. I was thinking about adding password protection to the workbook and when i open it and enter the password it will...

Hello all, I have been tasked with assisting the project manager of my company to help him calculate a standard formula to calculate the OT hours for x amount of people/wages. What makes this kinda difficult, (honestly it's probably not THAT hard, but I am rather rusty on excel formulas l0l)...

Hi, I want to know if I can make a formula in a simple way for multiple columns I want to know I have results in 18 columns, A3:R3 I want to know, on row 3, if 9 columns show values of 14 or over. I want the result to be shown in one cell, U3. And I want U3 to display 9 when 9 of the 18...

Hi, I have a data set as seen below. I am trying to calculate counting every unique match of entries in the People set A column to cities in the Places section. For example, strictly looking at Set A; Matt-1 has 4 unique entries (Philadelphia-1, NYC-1,NYC-2,NYC-3). John-1 has 7 unique...

Hi All, My issue is as follows, I need to create a formula that says if it breaches a threshold (e.g. 5%) then you need to disclose. But if it breaches the additional threshold of (e.g. 1%) then you need to disclose also. If a number was above 5% then you would disclose, but you would also...

Hey guys, I have been using excel for a long time now and I consider myself relatively good at it. However I have been having a headache trying to solve a kind of complex weighted average in a table like this: <tbody> Client name Broker Share Client&Share Quantity Avg Price (in Broker) Avg...

Ok so I regularly update files with hundreds of cell refrences to this workbook and different cells. Each year we recreate it and just update the year (i.e. from 2013 to 2014 as shown below. ='C:\Users\Me\Example\Issues\TEST123\Auto\2013\Fix\[How to 2013.xlsx]Tab1'!$A$1...

I need to create a "Calculator", which takes a date/time entered by the user, and adds a certain time (up to 100hours) based on criteria, giving a another date/time. To complicate matters, I need to exclude non business hours and weekends for some criteria, but not others. Example If Criteria...

Hi I have a problem that is hard to solve. Im looking for an VBA script (not funcion) that: 1. Compare entire rows (Column A-K) in Sheet1 with Sheet2 (Columna A-K). NOTE! Important that its entire row. 2. If it finds an dublicate somewhere show it in Sheet3 3. The big problem is that the rows...

Hi everyone. I've been having a few serious problems with excel and given I'm rather new to it all I'm really unsure how to figure things out. I've been searching the internet for a way to solve my problem and everything I have tried hasn't worked. I'm unsure which combination of match...

Below is the current formula I have that needs simplified...

Hey Everyone Me and my friend are often in charge of scoring the high jump at athletics competitions. At the mo, we are trying to make a spreadsheet that automatically works out the competitor rankings for us as it currently takes us a long time doing it by hand! Can anyone maybe have a read...

Hello All, I have a field in which a user must manually enter a date. The date field is used to caluclate a number of different cells which have IF Commands in them. The problem occurs when that field has not been entered it displays the value "0-Jan-00" (likely because I have that column...

Hi, I’m trying to work out which month a forecast is first made. Probably need to explain a bit more. I have a list of purchases along the left, 12 months along the top and then the various cost in the middle followed with a total at the end. I’m trying to work out which is first month the...

Hey all, I'm having a little trouble with a Macro at the moment, I need to copy 4 columns on one page, (A, B, C and D) and paste them into another sheet on Columns C, D, E and F. That I have achieved... However, I also need to filter out any row where the value of column A begins with a 6...

Is there a way to hardcode the results of a conditional format? For example, I have 2 columns of data that I'd like to hard code the borders produced by conditional formatting. I tried copying the columns, doing a paste special, and then selecting "formats," but that didn't work. As an...

h

I am attempting to perform a search on a data sheet containing multiple columns of data. The policy number input into PolicySearch_TB should search for a match on the input criteria, under columns:- ... K (PolicyNumber1_TB) ... AE (PolicyNumber2_TB) ... AY (PolicyNumber3_TB) ... BS...