#excel

Hello Team, Iam looking for a formula to calculate working and non working hours then should be returned in form of hh:mm:ss.

I have some lambda functions defined in the name manger. Is there a way to list the content of a lambda function in a sheet, just for reference? It is nice to see the full lambda function to study as the name manger is not optimal for viewing lambdas. For example, I named lambda, "fn", which is...

Dear All, I am a beginner in VBA and I wan to know the simplest way to add conditional formatting for my Macro. please help.

Dear All, Anyone can explain me how to do color format for the cells as shown in the picture. I wanted to use color gradient (not conditional formatting), however the border differentiation is not working for me as shown in the picture :

Hello everyone, I need the sum of data, for example, from "G57 to G110" which will be expressed in cell "G111", but if I add rows above G57 afterwards, then the formula gets messed up (lose its check mark or give me wrong checks). So, I need a formula that will SUM the data from the first cell...

Hello Team, Is there a way to effectively generate a set of shifts or schedule with the given required headcount per interval in a 24/7 coverage? Let's say; * Required headcount per 30-min interval was given (Monday to Sunday) * 2 days off per employee - 4 Hours for Part-Time - 9...

Hello everyone, I would like some help using the IF formula to separate diamond classes from trees. Thanks in advance.

Hello, I would like to get help with calculating life insurance premium/cost where the cost is based on age band and coverage amount is in units of $1,000. Please see attached sample sheet. If a person enters his/her age and desired coverage amount in cell B1&B2, the formula looks at rate chart...

I am new to Power Query and I have been running into memory issues when using large time series data sets. An I am wondering if it is a usage issue on my end based on me not fully understanding how Power Query handles large data sets. I was hoping someone could clarify a few items for me. What...

Hi Everyone I wanted help finding the number of Google search results for each keyword/Box. For example: Google search results for these keywords are: Football: 3,920,000,000 results Beauty: 6,470,000,000 results Cinema: 2,870,000,000 results What I need is a formula that provides me with these...

I have both sides of the code but do not know how to join them together. One part of the cod will pull the Windows user name but not work with a selected range and not work with if there is a change in that range. The other part works with with timestamping when ever there is a change within a...

Hi, I work for a TV media buying agency and we work off of a broadcast calendar It is VERY different than a standard calendar. (see attached). We need to find the Broadcast QTR, Month & Year for any given date very regularly. I was able to find formals to calculate the Broadcast QTR &...

Hi, I'm trying to create an inventory sheet on excel. How I'm able to scan in a barcode on cell B3 and move all the data down one row only for column B, not the entire row. I would like this to work for each separate columns so if I scan a barcode on cell C3, all the data just on column C...

Hi, Wanted to make a worksheet where I can save bid/invoices in a different sheet (to keep track of it) but I also wanted to save it in a specific location each time I click "Save All". Right now I have it so that it saves in a specific location, but I want to make it so that I can put the...

In this data set there are 3 separate policies that are either have 6 month or 12 month terms. I want to define each policy as 'NEW' for the first 12 months - i.e. For ID '01' in E2:E4 it is labeled as 'New' only once and I need a formula to turn it into F2:F4. I only need to change New/Renew...

I need to modify a bunch of excel files, for any row that contains the word "Skimmer", I need to move the value from column B (same row) to in front of Skimmer (always in column K) like this: (1)Skimmer, (2)Skimmer, (3)Skimmer. (The value in column B does not need to be removed) see below for...

I have data that contains the sales per 3 different customers per the 14 states in Germany and I wish to be able to see all the sales on the map and to be able maybe have a filter of the customers. My current challenge is: the map only shows me the sales of one the customer despite selecting all...

Hi all I am in a trouble to sort out the following to find out exact sum of the pay based on certain role and time period: In one sheet there are names of the positions and per period pay amounts In another sheet, there are positions and the names as well as their tenure/working period during in...

Hi there, I am having some trouble using the COUNTIFS function. I want to determine whether a certain combination of responses occurs in cell pairs. For example: = SUM(COUNTIFS('P2'!B7,{"Sometimes","Often","Always"}, 'P2'!C7,{"Sometimes","Often","Always"})) When I try the formula in full...

I need to use VBA to move the first 3 characters from column O to in front of the text in column K, so in the example below it should look like: J-7,4x8',Base,8"w,96" appreciate your help !