Search results for query: *

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!

I have a formula that is giving me True or False. I need the intended Value not True or False. Appreciate your assistance. If GroupName ({vActivityRpt.SalespersonNo})="xyz" then {vActivityRpt.SalesManagerName}= "John Doe" OR if GroupName ({vActivityRpt.SalespersonNo})="abc" then...

Thank you so much. I used the OR TRIM syntax and it works.

If a field is null, I want to replace it with "In Transit" else the field. I have tried various syntax to no avail. The "In Transit" does not appear in the report for blank warehouse city. I have Default Values For Nulls selected Formula below: if isnull({IM_Warehouse.WarehouseCity})then "In...

This is the situation. We have invoices and credit memos. The Credit memos in our system do not differentiate from invoices. so if an invoice is 26,000 and there is another "invoice"(credit memo) for -26,000 that cancels out the original, then I do not want to pull the original invoices or...

In an instance that I have an invoice total of 26000.00 and and invoice total of -26000.00 then I do not want to see that invoice. What would be the coding for that instance? I just want to see invoices that total >=15000.00 however if there is a another invoice which zero's it out, I don't want...