User Profile
NewelleNielsen8821
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: TO FIND OUT DIFFERNT VALUES IN AN ARRAY OF TWO COLUMNS
I have this same question, Ihave a row of data that I'm trying to see if all are the SAME, but standard if statement I can only compare two at a time - tried to configure an XLookup but not getting it. The Example below I want a "FAIL" because they are not all the same. Know its a fairly simple one but brain just isn't getting it today. Thanks! Preventive Care/Screening/Immunization $0 $0 $25 $0 $0 $0 $0 $0 $0 $0671Views0likes0CommentsFinding Dupes in column array in excel
Hello, I have been tasked with takin the data provided (just a small sample) to identify if the plans have all the same elements configured the same. I have Attached the example and basically need to Identify Each of the Plan Marketing Names that have the same plan configuration (Rows 9 through 152) into a new worksheet that shows the duplicated plans together and the unique one separately. PROBLEM 1 - need the Check columns I started for the first 3 to be a function for the entire data set in each tab which is 77 Columns long. PROBLEM 2 - need to do this function across several tabs PROBLEM 3 - need to do this function across several different documents400Views0likes0CommentsRe: Enumerating Smartly in Excel
Good Suggestion however I'm new to the organization so would have to check with the PMs and above to ensure as they are used to just seeing the active ones and remembering to filter is asking - however could do a pivot or something......will consider that and again appreciate your quick responses!1.5KViews0likes0CommentsRe: Enumerating Smartly in Excel
@Riny_Van_Eeklen403176 This is SO GREAT - thank you - my next task is to ensure that if a row gets deleted that the number stays the same - do I have to do that in a Macro to set it to text once identified? It has to be dynamic to a point as new things are added throughout the project and others are moved off but they need to keep their values so it would need to be dynamic for the new entries only and the once established no changes. Hopefully that makes sense.1.6KViews0likes2CommentsEnumerating Smartly in Excel
Hi I have an excel question - I need to have the function be smart enough to do two things: 1. Determine the first integer of a value (ex x.xx) using Report Category column (SEE BELOW) based on 1-5 Values 2. Find the largest value in the column with the numbers in it and add .01 to it. This is the hard part as the first integer needs to be taken into consideration first and then look at the trailing 2 integers after the <.> to get the value to start with then add the .01 to it. Below is an example of what I have so far showing what I need - NOTE IT WILL NOT BE IN PERFECT ORDER BY THE REPORT ID - IS FOR THIS EXAMPLE ONLY: I used this function to get the first integer =IF($D4="External Client Regulatory","1.",IF($D4="External Operational Request","2.",IF($D4="Evolent Standard Operational","3.",IF($D4="Evolent Vendor Operational","4.",IF($D4="Evolent Internal Operational","5.",0))))) But after that I can't figure out what to do to get the correct trailing numbers. It does not need to be dynamic as we often times add and delete rows from the output so the numbers should stay the same once they are assigned. Report ID Report Name Report Category 1.01 Anthem & EMBLEM Call Center Stats Report External Operational Request 1.02 Anthem & Emblem Care Program Details Report External Operational Request 2.01 Anthem & Emblem CMART External Client Regulatory 2.02 Anthem Newborn Kick Payment External Client Regulatory 5.01 Internal Anthem Weekly Auths File Evolent Internal Operational 5.02 Internal Emblem claim denial and adjustment details Evolent Internal OperationalSolved1.8KViews0likes6CommentsRe: #spill Error
well instead of have the C2:C27 I wanted to use something like this =COUNTBLANK(ROWS(Colorado[Regulatory Reference])) & " REG NEEDED" but that isn't working I tried IS BLANK with the same and it doesn't work either. I just wanted to make so I didn't have to check each tab for the number of rows and update it all manually as noted in red below =COUNTIF(G4:G31,"TBD") & " TBD RESOLUTION NEEDED"2KViews0likes1Comment#spill Error
Hello I have this function above a defined table =ROW(Colorado)-1+COUNTA(Colorado[Description]) The Error states its a "Spill Range Isn't Blank" and when I select the Obstructing Cells its everything in the column I defined. Is it because Its on in the table itself?Solved2.3KViews0likes8Comments
Recent Blog Articles
No content to show