I have a very large Excel chart I need to select nonadjacent cells from different columns from to copy and use to create line graphs. Is this even possible?
In general yes. How to select nonadjacent cells is here https://support.office.com/en-us/article/Select-cells-ranges-rows-or-columns-on-a-worksheet-23f64223-2b6b-453a-8688-248355f10fa9
Or you may create the graph directly on your data - start with any one and after that through Select data change your axis and series label on selection your need. By selecting as above, or better manually. e.g. for axis label that could be
similar for series
A customer would like to register his legacy devices (Win 7) in Azure AD to take advantage of Conditional Access scenarios with corporate devices.
We just configure and install Skype Room System v2 with Logitech Group and Logitech Smartdock.
All is working fine instead of "Content", if I put in attachment powerpoint file in the meeting request, it isn't display in the content menu on the... Read More
Can someone help me resolve an If formula in excel 2010 please? I have a workbook with multiple worksheets. I'm trying to copy the cell value that is not blank from one worksheet called Payment Calc to another with my If statement. My formula in the de... Read More
They are all have formulas and they all read as False. That said, the first three conditions do result in their values being copied into the destination cell when they have data. For some reason the final condition will not populate even if I adjust the formula. So strange.
I've attached my workbook in hopes you can replicate the issue. The destination cell with the If statement in question is in D10 on the Credit Report tab. The Payment Calc tab has the four cells the If statement is targeting. Two of the cells have imbedded If formulas and the other two have imbedded Max formulas.