Recent content by jlr123

I want to highlight all duplicates based on the first text of each cell in a column. There are many but this based on any duplicate first text word in the column not just a specific text. E$5:E$132

Just what I am looking for combo! Thanks.

I have a table that has many rows with one of the columns which has an non-calculated percentage. I want to create a pie chart with this column as an axis. How do I do this? See attached example. thanks for your...

When I tried search and replace, I got this pop up message: "Excel found a problem with one or more formula references in the worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

Yes I understand, but I want all rows in my table to change to the new name of the workbook but leave the rest of the formula. i.e. '[New Workbook.xlsx]Bill Jones'!H15 next row would be '[New Workbook.xlsx]Bob Smith'!H15 etc for each row. Thanks for your assistance.

Hello, I want to copy a worksheet from a workbook into another workbook but keep part of the formula. Delete the .xlsx file but keep the Bill Jones K15 portion ='[Total Commissions_Revenue Feb 2023 (Executive Only).xlsx]Bill Jones'!H15 Thanks for your assistance.

The second one should be used for solution. I am waiting on Management to get back to me regarding ,more than one customer number starting with "0" and more than one 15000 account number. Will get back to you. Thanks!

Please see attached.https://files.engineering.com/getfile.aspx?folder=718353b5-ee9d-488a-8494-bb91fba6aca8&file=Tek_tips_Excel_Wksht_Revised.xlsx

I have added a new raw data sheet for this thread.https://files.engineering.com/getfile.aspx?folder=b07da47b-dfaf-4ef8-b97d-4e93785e3883&file=Forum_Excel_Wksht.xlsx

I have raw data which has the same address for two or more customer numbers. I need to show one customer number in one column and the the other customer number(s) in an adjacent column with a summary of Amt by Department. I have tried to utlize pivot table but unable to get the information the...

Thank you so much!!

I have this formula in a report which I need a Grand Total DistinctCount ({AR_Customer.CustomerNo}, {AR_Customer.SalespersonNo}) - {#CustomerCountNoYTDSales} (this last part is a running total formula: Sum ({@YTD}, {AR_Customer.CustomerNo})=0 What I am trying to get is a Grand Total of Distinct...

I need a formula that represents the folowing: If b2=c2 and R2>0 then R2 else 0 Could use the help today if possible. Thanks very much!

My date formula for only viewing specific dates exports to Excel as 1/0/1900. What can I do to get a blank date in Excel? (blank dates viewed in Crystal exporting as 1/0/1900) My formula: if {AR_InvoiceHistoryDetail.UDF_CC_CODE}= "Rent" then {SO_SalesOrderHeader.OrderDate} Thanks very much.

Thanks so much. I keep learning every day!