primary

  1. A

    Tag duplicate rows based on a specific criteria

    Hi Excel Guru's Need help please, I know what my logic should be, I know what my result should be, but I am unable to build any formula to show the result I need. Below is the data set up and three different scenarios. The column named [Primary File Number line TAG] is where I would like to...
  2. Alphacsulb

    Feedback/Ideas for Email Group Generation

    Hello, I'm looking for feedback on developing an email group database that will turn into a macro to create a lists. I have 6 sheets: Primary (Primary Directors) Alternate (Alternate Directors) Secondary (Second Alternate Directors) Managers (Other Staff who also receive information) Staff...
  3. S

    IF with two conditions

    Hi I need formula with if command in column E based on data from A to D, Secondary no Discount <tbody> Segment Transmission Value Discount % Result Primary AUTO 1000 20% 200 Primary<strike></strike> MANUAL 1000 10% 100 Secondary AUTO 1000 0% 0 Secondary<strike></strike> MANUAL...
  4. D

    VBA code to reset dependent dropdown

    Hello, I've got a workbook I've been working on with primary drop-downs located in col G, cells 13, 14, 15,(merged cell with H&I), my dependent drop-down is in C of the same rows. (Merged cell with D). Despite trying codes copied from forums here and adjusting the locations to my situation, I...
  5. A

    Join between tables

    Hello, Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields. For example in this...
  6. R

    Retrieve last non-empty cell based on date criteria

    Hi. I have difficulties with resolving the following issue: I have the prices for the Product #1 that are monthly revised (Table _ Primary data). Some months are blank, that means there were no price review in this period (e.g. as of 3/1/2019), thus, the price of previous month remains actual...
  7. B

    Formula help

    hello, looking for some help, hope i explain this clearly. i have two sheets of data, what i would call a landing page where i am populating the data form the 2nd sheet titled DATA the first sheet has primary keys as an identifier in column A, which pulls from the corresponding primary keys on...
  8. L

    Converting multpile rows per patient to one row per patient

    Hi, I have a table of patients and their diagnoses where eachline contains a separate diagnosis and there can be many lines per patient. I need to convert this to one row per patient with all ofthe diagnoses ordered Primary 1 diagnosis code, Primary 1 DiagnosisDescription, Secondary 1 diagnosis...
  9. T

    Help with possible Index Match Match?

    Hi All, This may be an impossible task so bear with me. I have the following raw data: <tbody> Owner Account ID Industry Industry# Account # Joe 1 Plumber Primary Industry Primary Account Joe 2 HVAC Secondary Industry Secondary Account Bob 3 Plumber Primary Industry Primary Account...
  10. V

    Merge Data cells based on Primary Key

    Hello all I hope you can help on this please I have a workbook which is sent out to a user to update Columns "W" & "X" Columns "C" & "H" & "O" combined make up a primary key I want to save the users updated file in a folder Open up my master file and run a macro that points to the folder...
  11. W

    Identifying Duplicates and assigning a 'Rank'

    I have a file with 1331 account ID's, I can use the count function to identify if an ID is duplicated, is there a way to identify which of the duplicates is the primary duplicate? For the purpose of this, the primary would be defined as appearing first in the order (row number)
  12. U

    Remove Row and move cells

    Hello I have a file dump from my business system and i would like some help on how i cam remove a row; and shift cell contents up one row if needed i added a sample file here (top what i have; and bottom what i would like to see) <tbody> Item# Desc Loc Unit Quant Cost Value Anchor Shackle...
  13. K

    Force Excel to always open on Primary Monitor

    I have 3 monitors. Excel seems to arbitrarily open on one of the other two monitors other than the primary. If I move Excel to the primary monitor, open a new worksheet (in the same monitor) and then close Excel, it opens in the primary thereafter. I want to find a way to ALWAYS under any and...
  14. C

    VBA Button to fill in data based off dropdown list value

    I have 10 rows of data with one of the columns called "Type". This column has either "Primary" or "Secondary" entered in. I then have a column at the end called "Provider" that needs to be filled in based off the functions of my "Primary" button. The button essentially will fill in the...
  15. V

    Vba code for lookup if the value exists

    Hello all I need an excel guru to solve this one please I have multiple lookup's against a primary key in two work tabs This then brings through the data I need The problem I have is if the source line no longer exist the lookup will wipe out the last data that was in the cell.. I need...
  16. N

    VBA Excel Graphs

    Hello Everyone - I'm looking for the VBA code that I can use to automatically adjust the min and max on both the primary and secondary axis on each graph within my spreadsheet. I have found the code to adjust all min and max on each graph, but that same code doesn't work when I have a graph...
  17. K

    IF Formula

    Hello, I have a set of data with a primary ID and a calculated field (number). The primary ID can appear multiple times within the data set, with more than one calculated field values. I am looking for a formula to ask the data set, look through at each primary ID, and determine if at least...
  18. A

    Switching x-axes from horizontal secondary to primary

    Hello! I have a chart with 4 axes (i.e. horizontal primary, horizontal secondary, vertical primary and vertical secondary). I'm using Excel 2016 and need to switch the horizontal secondary axis at the top (date) with the horizontal primary axis at the bottom (number). Unfortunately, I...
  19. G

    Help for Power Pivot Data Model

    Hi Experts Looking for suggestion on Data model(PowerPivot) with Fact and dimesion for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region [ fact Table ( below is example of 60000 R and 90 C) ] I have create 3 dimension tables 1. Area ( Primary...
  20. P

    Employee forecasting - Multi-criteria calculation

    Hello everybody. <o:p></o:p> I’m a bit out of my depth with this one! <o:p></o:p> Effectively what I am trying to do is calculate the time commitment of each employee based on a number of criteria. <o:p></o:p> <o:p></o:p> Each employee is allocated to a number of jobs – the time commitment for...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top