“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How do I create a function to replicate text in a cell if a preceding cell has text that is BOLD?

Solved by O. H. in 13 mins

How do I setup excel conditional formatting based on text in another cell?

Solved by E. Y. in 16 mins

Need to modify an If formula to display text only at a certain value

Solved by C. J. in 28 mins

Hello,
I'm working on a spreadsheet and I wish to have both formula and text in the same cell
for example: [=(A1+B1) cats]
I hope you can help me. :)

Solved by F. H. in 16 mins

Sumif help to display text once the cell is over a certain value

Solved by M. H. in 17 mins

I can't use my new data for different value field settings in the pivot table apart from count, it says can't summarise this data as it's not a supported calculation for text data types

Solved by D. F. in 14 mins

In cell L2 in the Valuable worksheet, enter a nested logical function to display Highly Valuable if either condition is met:
*The release date is on or before December 31, 1994, or
*The sold-out status is Yes, the percentage increase in value is at least 500%, and the Edition Size was less than 700.
Enter an empty text string if the two conditions are not met.

Solved by I. F. in 21 mins

This request is for the tab “TrueUp AddProd”. I require a text to be calculated on Column R “Tier”. If the “Product Family” in Column Z, matches the Product Family on tab “Tier”, list the value of the Tier on column B. If no product family match is available, list “Core”.

Solved by T. J. in 16 mins

Need to have formulas perform a match on specific text from another tab.

Solved by Z. H. in 29 mins

This request is for the tab “EA Agreement Renewal”.
I require a text to be calculated on Column R “Tier”: If the “Product Family” in Column AB, matches the Product Family on tab “Tier”, list the value of the Tier on column B. If no product family match is available, list “Core”.
I can’t get the formula on column R “Tier” to work. For some reason, only the value of “Core” is appearing.

Solved by G. F. in 28 mins