pro

Hi All i have attached the sheet with made up sample. in sheet 4 there is column C and E is the data which i received and i want result of column D and F as i mentioned with reference to subject of this post! column C and E is linked with sheet 3 columns, there is mainly two types of packages...

Hello All, This thing has stumped me. I trying to separate a bullet point list from one cell into different columns using this formula: =TRIM(LEFT(SUBSTITUTE(MID(D4,FIND("|",SUBSTITUTE(D4,"•","|",1))+1,LEN(D4)),"•",REPT(" ",LEN(D4))),LEN(D4))) It works most of the time, but sometimes it...

just moved from old laptop to new laptop : old laptop: memory : 8 gb , win 10 , office 2019 pro, 1000 hard disk 5400 , 4702HQ intel . new laptop: 16 gb, win 10 pro, office 2019 pro, 524 SSD , 9750H intel. all I got out of this is merely 15% faster excel on the opening, I got large excel...

Hi Everybody, Can you help with a formula to removed everything to the right of " (" in column A and put the results in cell B as shown below? Thanks so much for your help! Thanks, Dan <tbody> A B C D 1 154-150 (154-150 Digi Pro... 154-150 2 154-154 (154-154 Digi Pro... 154-154 3...

Workbook with 3 sheets: Timesheet, Charts, Data. ONLY the Timesheet when I enter a number or time, calculation is slow (~5-6 secs). It does not happen with alpha characters. Dimension for Timesheet is A1:AG566 A few vlookups and many if statements. The thing that puzzles me is this happened...

Hello Guru's ALT + ENTER and some spaces NOT IN VBA! What are the disadvantages of this neatly coding in Excel formulas, aside from I have to manually type the spaces? =IF( COUNTIFS( P23:P40,">="&NUMBERVALUE("04/01/2019")...

anyone have any suggestions for this. so i am including calculations per quarter. so jan - mar apr-jun etc. what i want to do is pro rata people based on their start dates. so if the person started then pro rata this so they dont get full payments. i am waiting for someone to send me a working...

I am looking for a way to calculate monthly and annual pro rata so that it automatically adjusts to the current day and month and year eg September has 30 days and on the 15th day of the month the prorata is 50%, 10th day of september is 33% etc but when it changes to october i would like it...

Hello, I need to make a sort of weights calculator that i could just put in the number of projects i have, rate them from most to least important, and the percentage of increase and it would automatically give me the required weights. For example, right now I have four projects: Pro. A Pro. B...

If I subscribe and pay Power BI Pro (web), is there any space up there I can upload my data.xlsx there and the Power BI then get data from that file in that web space provided by Power BI Pro ? Please help. Thanks

I’m looking to do some conditional formatting on the excel app for iPad Pro as in being able to autocapitalize and change fill color based on what letter is typed in to given cells. Is that possible on the app for excel? Does that require an Office 365 subscription? Any help would be...

I want to know if this is possible with one formula in C13. This is the scenario. How many times occurs a team from column A in Column D and then multiply with the points in column B. Column C is just the intermediate step for clarity. End result is in C13 where the formula comes...

I have an NFL spreadsheet the family & I have been using for over 20 years I created in Quattro Pro. they are bugging me to convert it to Excel. There are a couple of formulas I need help with. The 1st one is: IN QUATTRO PRO ...... Array(@IF(@ISBLANK(J10),"",@IF(J10>L10,A10,N10)))...

Hi, Microsoft brought out an Add-In for Word & Powerpoint 2016, but not for Excel 2016, called Pro Word Cloud. My data/text to drive the production of a word cloud is sat in Excel and I would like to be able to copy the text to Word, have a word cloud produced, and then for the cloud to be...

Hi in an excel sheet colomn have cell having multiple paragraph with Dates in it after a particular text " On" i want to built a formula which will look for the specific text " On" and extract the date after it only for the first paragraph in the cell. comments "MAC Book Pro - 2,450/- Per...

hello i need help with figuring out a formula to prorate a persons sales for the year (based on monthly) if column A had for example 735,556 and this person had come on in February- how would i pro rate their sales ?

Hi again Excel Experts, I was working in something and think that maybe you can help me to not to expend hours doing something like this I have a Product name with certain values in column B like this: All in One HP Pro One 600 G2 21.5” Intel Core i5-6500 8GB 1TB Windows 10 Pro All in One Dell...

I have a macro obtained from this forum (THANK YOU!) which allows me to print a list of pdfs. However, in order for this to work, I have to hard code the filepath (and hence version) of adobe acrobat being used on my system. How do I build into the macro a routine which will search a given...

Hi, great site, been an observer for a long time. Having alot of problems with address line separation and cant find any answers unfortunately. The two addresses i come across are. Line1 Line2 Line3 (occasionally) City County P0S CDE or Line1, Line2, Line3 (occasionally), City, County...