primary

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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)

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...

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...

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...

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...

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...

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...

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...

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...

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...