User Profile
ERBAE200
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Finding / marking errors with formula depending on two rows
Hello, I have attached an example file to understand my issue. I want to use a formula who is able to detect if a number in row A has more than one number in row B. Per each number in A only one result is allowed to be in B. How can I mark them all red? I also tried to create a function, which is looking for the same number in B, 5 rows above and 5 below. We are talking about 12000 rows and my functions mostly went to an error. Thank you so much in advance. GreetingsFind wrong data in this specific case
Hi, sorry for bothering again. I was using a formula which got some errors because of some cells with multiple numbers in it. I want to find cells where multiple numbers are. Blank cells are fine. Does anybody has an idea? You can see an example of the file attached - the green box shows the cell I am talking about.How to sum up with conditions (complicated)
Hi there, I have a quit complicated question about programming with Exel. I tried to Google it and some formulas myself but it wasn’t working - maybe somebody has a solution for me. I have just added a picture of the sheet to visualize the problem. I want to fill the empty gaps in column C with the summed amounts from the transaction from column B with the same transaction number from column A. Unfortunately these gaps are on different position. It’s a very long sheets why it’s impossible to to it manually. Does anyone has an idea? P. S. If it’s easier I could also go with the results from column C being in the column of B but as an negative amount. (And deleting column C) thank you so much!
