achieve

HiAll Hoping you could help me achieve this layout I have a pivot table that stores the location in thr rows Either Office Home I have downtime Printing in values and Downtime standard in values too The problem im having is that Downtime Standard appears in both WFH and office I want to...

Hi I am trying to input a formula into column V as below. I get a Compile error: Expected end of statement message pop up. Dim lastRow As Long Set fnd = Range("A:A").Find("Currency", , , xlWhole, , , False, , False) If fnd Is Nothing Then Exit Sub lastRow = Cells(Rows.Count...

Hi all Tearing my heair out all afternoon with this ..... I have a table of data which I am using a chart and then I want to use the trendline equation from the chart (polynomial formula) - in other cells. I am using the INDEX / LINEST function .... but the function is giving me different...

From a previous post I have been using the function at the bottom of the post. I now wish to use the aggregate function again to find the Max value from a different range of cells but still based on only those records that are in a particular year. I have tried modifying the function as below to...

Very Simple, but i dont how to achieve this..can someone rectify my code If Workbooks("workbook1").Open Then Workbooks("Workbook1").Close End If

wonder if anybody here would be kind enough to help me with this headscratcher. i am working on a gross profit calculator for a restaurant. i want to include 3 methods of viewing the affect on gp. increase to (new price) method, and increase by (fixed amount) method are straightforward...

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example...

Hi there, I am new to Access and haven't used query before, so explaining things in query to me is probably a bit useless. Anyway, I want the ProductID's to show up in my Employee field, but I am having trouble doing so. I was able to achieve this in my Materials table with Employee ID, which...

I need a nice button to on tab named "Control" with the following VBA code to achieve the following: In "BBB" tab copy entire columns A and B to the last empty row, then paste only values it in from cell A1 in sheet named "NEW" Next In "AAA" tab copy entire columns A and B to the last empty...

Hello, I have around 80K entries, what I would like to do is find the duplicates and extract them to a different document. how can I achieve that? Thank you.

Hello, I need to mark consecutive more than 5 Non-Blank cells in excel like given below. It will be good if this can be done in VBA Macro. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD 2 5 3 4 3 3 3 4 3 3 2 3 3 3 3 3 3 3 4 4 4 4 1 2 3 4 5 6 5 7 7 8 8...

As per the spreadsheet located at: https://drive.google.com/file/d/1B9s5sQucM8EWZpDNDWx9t4TSCRNvGa8Q/view?usp=sharing I want to give each user the utmost suited film or genre (I think genre might be easier?) to them as a recommendation in the ratings tab, I have been trying to analyse the data...

Hi, I'll try to explain it with the help of the table at the end of this message. I want to "pull" only these values of column Y (for a value comparison in a different table) that are dependent on the same value in column X. In the table, the first four values in column Y have got the same X...

Hi, I have to make a simple query in access, here are the pictures which explain what is to be done. So, I want to achieve somthing like upper picture, but I dont know how to organize it on lower picture... Thanks in advance...

I am creating one word report (Office 2013) using mail merge wherein data will be fed into excel sheet and it will be used as a data source for mail merge. I am able to achieve all this, but now I have a requirement of Tables in the same word report . The table is dynamic in nature, I want to...

Hi all, Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results. I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a...

I've got a field in excel which a program spits out the account name and number concatenated. For example: abc100 abc200 abc300 defg defg100 defg200 defg300 There is no standard formatting so the account name, or number don't always contain the same number of characters. What i'm trying to...

https://drive.google.com/a/writingline.com/file/d/1TLHGZw3XuXqn3CkziIjqDFwhjeaccopc/view?usp=sharing Here you can see an example of what I want to achieve. Please let me know the simplest way to divide the value? Thanks

I am wanting to achieve a countif which will refer to a different cell to decide which column to count. Example: I have data in 8 different Columns, labelled 1-8. I want to count the pieces of information in each column using countifs, however this will depend on the value in A1. (i.e. if I...

Hi everyone, The following relates to the website https://rid.tcdc.govt.nz/ In the past I have had help from this forum in getting data from here using vba. Unfortunately this site has been rewritten and now I am stumped again. For example, if I wanted to know the Capital Value of the...