partner

Hi Experts, I wrote below code in a form for my team. It's a simple 'open file - copy - paste' exercise but for some reason a bunch of users are getting these random Automation Errors. I believe it happens when two big files are opened. Some users fix this after a restart and I had one user...

I've got a large table of values, 5000+ rows long, and about 20 columns wide. In that table are multiple items with the same partner name. I need to pull all of the entries out of that table for a specific partner. There may be anywhere from 1 to 20 occurrences of that partner name in the...

Hi all I have two lists of partner names - one has just a list of names (and some other related data) - (Partner ID's), the other has a list of names with a corresponding ID number (Partner Data). So I have this formula in F1 in the sheet Partner ID's: =IF(E1="None",COUNTIFS('Partner...

Hey guys, im very new to excel and its mind blowing me right now loll. I could use some serious help lol, unfortunately i dont understand what my partner has already done. I am happy ot teamviewer please just msg me in private and ill explain what i need via discord, whatsapp or in a text box...

My initial problem was this: Ihave a coworker that maintains a spreadsheet comprised of several tabs, thefirst is the main and contains all the information about each business partnerwith columns showing their 1st choice wholesaler, 2nd choice, 3rd choice and soon. And then there's a tab for...

I have multiple pivot tables (PT) in a workbook, which are all based on the same source data. Each pivot table is identical except for the unit acronym used in the Report Filter. I just noticed an issue with one of them, and have searched for a while now, without success. I'm certain one of you...

Hi All- I have been working....struggling on an excel sheet to determine the commission split among 2 partners on a per deal basis which would include the reimbursement from Partner A to Partner B for the acquisition of the company. (Here is the link to my XLS sheet. ) Here are a few things to...

Hi guys, Encountered with a problem where I have recorded macros to find out specfic values using vlookup. In Column, XEZ6192, there are partners, city and agents available that are linked with Column N2 and onwards. Now issue is whenever I add new partners down in Column XEZ, it always gives...

My first worksheet has a list of projects with Quarter, Partner, Date Live, and Project name. It is in a column style format: WKSHT 1 <tbody> Quarter Partner Channel Live Date Project Name Q1 Company 1 1/1/2018 Project 1 Q1 Company 1 2/1/2018 Project 2 Q1 Company 3 3/6/2018 Project 3...

All I am having issues with embedding multiple if scenarios with OR/and logic. In sheet1, column A = system titles in sheet 1, column B = # of years in sheet1, column C = if statement required (client titles) in reference sheet, column A = system titles in reference sheet, column B = client...