1. R

    Populate then clear

    I'm trying to take a snapshot of600+ different options quotes using my brokerage's RTD API, but they limit meto 100 requests at any one time.<o:p></o:p> I have a Range of cells that theRTD formulas are pasted into then once values have been generated (each cell inrange is > 0) to delete the...
  2. P

    calculate the delta values in the vertical and horizontal line of the draws.

    calculate the delta values in the vertical and horizontal line of the draws, delta is the memso that distances, in the vertical is always from the last to the next, horizontally, we have 6 values because the base is the 1st number, already in the vertical we have 7 delta values or distances...
  3. rjbinney

    STDEVIF Function?

    I know I can do this in Pivot Tables. I want to do this with formulas if possible. I have a list of products (about 30) (named "SKU") and how long it took to run each (named "Actual") (some ran two or three times, some ran up to 60 times). I need some information about how "in control" the...
  4. C

    Volume breakdown/distribution to return and receive

    Dear Friends, A have a list of people with volumes to return and others to receive. Ex: Alpha returns 500 Bravo returns 750 Charlie returns 50 Delta receives 200 Echo receives 600 Foxtrot receives 500 I would like to automate the distribution between the parties, resulting in the end on...
  5. H

    Earliest date with conditions

    Hi everyone, Can't seem to make this work... I have a table like this: <colgroup><col><col><col></colgroup><tbody> Vendor invoice nr invoice date Alfa 1 11-10-2018 Beta 23 10-02-2017 Beta 24 01-03-2015 Delta 58 06-04-2016 Delta 59 07-04-2017 Delta 60 08-04-2018 Gama 70...
  6. A

    Complex count and lookup criteria with multiple values - SumProduct???

    Following on from a question I asked a few days ago, I need to calculate the below I have a control Table, indicating whether each Team should be included in the results <colgroup><col><col><col></colgroup><tbody> A B 1 Team Include 2 Team Alpha Yes 3 Team Bravo No 4 Team...
  7. T

    Multiple formula tasking

    <colgroup><col><col span="3"></colgroup><tbody> ITEM DATABASE 1 DATABASE 2 DELTA TRUCK STAKE 6X6 46000 GV 183 184 100.55% TRK STAKE 46000 GVW 161 161 100.00% TRK SUV 8600 160 152 95.00% A formula for all cells under the delta. If both databases match, they should be at 100%. Trying...
  8. A

    Deleting Rows Containing Reversed Names

    I have a worksheet in which one column of data contains pairs of competitor names which also appear reversed in the same column. E.g. Alpha v Bravo Alpha v Delta Alpha v Echo Bravo v Tango Foxtrot v Delta Delta v Alpha Echo v Alpha etc. I require only one instance (row) of each pair of names...
  9. O

    Retrieving data from a .txt file

    Hello, I would like to know if I have data file in a specific folder named ="Folder A" which will be residing on my desktop at all times, would I be able to retrieve data from the last created file type = ".txt" from it. Can I do it via VBA scripting of some sort? The data in the .txt file may...
  10. C

    Dynamic Function name in Power query

    Hi Guys, I have been looking online for a while now and i cant find a way to create a dynamic way of naming a function inside the data model. Let's say I have a Dataset called A and one Dataset called B (Txt files) which have the same layout that i am cleaning and appending through power query...
  11. L

    Sort data in pivot table based on value outside pivot table

    So I'm having a problem sorting data in a pivot table based on a "delta" formula outside pivot table; e.g. outside is % Delta, Inside pivot is all other data Dimension Question 2016 2017 % Delta My Work Experience 84.8% 87.3% 3% My Work Experience 86.0% 87.8%...
  12. R

    delta symbol new issue

    Hi again, my last post asked about putting the delta symbol in a validated cell from a list, which also included the letter Y. That is working great thanks to the help i got. The new issue is that I have a cell with a formula referring to the results of the choice in that validated cell. The...
  13. R

    delta symbol

    Hi, can anyone tell me how to get the delta symbol to stop showing up as a capital D? Thanks, Rick
  14. O

    How to condition format Datafields in Pivot with VBA?

    I have a Pivot table that looks like below. I need to conditional format just the WOS row to highlight cells that are less than 0 in red, 0.1 to 1.5 in yellow and anything above 1.5 in green. The pivot must keep the formatting when I move the pivot fields around. I have made various attempts on...
  15. Nelson78

    Copy and paste columns

    Good morning everybody. I've my workbook with a sheet named "One" with four columns, "Alpha", "Beta", "Gamma" and "Delta". Another sheet is called "Two" where you can find a lot of columns among which "Alpha", "Beta", "Gamma" and "Delta" that could change their position every day. Now, I need...
  16. D

    Help with Formula - Two criteria

    Hi All, Thanks for helping in advance. I am trying to write a formula that uses two criteria to return a value. I've trawled the net for a solution or previous responses, however I cannot replicate them to a satisfactory result. I need a formula that checks Criteria A, as well as Criteria B...
  17. H

    Pivot Table Fields to Calculate Delta between two proceeding Columns

    Hello, I have a Pivot Table that I would like help with. I have two Columns Currently Current Week and Previous Week. The Values are displayed as a count for the Status Field. I would like to know if it is possibel to add a calculated formula that will take the count difference between Current...
  18. C

    Pivot Table delta

    I have a report that shows the # of jobs from year to year in the columns. I created a bar chart that shows the data. How can I show the differences in the chart in percentages? :eeek:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back