Forum Widgets
Latest Discussions
Delete extra row
I have a document with 95 people, where I fill in 1 row for each of them for each day. One day I fill in 91 rows, the second day 89 rows, the third 94... (each day a different number of rows to fill in). After that entry, for each person I need to have 24 filled in rows for the last 24 days when I entered data. The next day I enter data for 92 people, for those 92 people I will have 25 filled in rows (the 25th row is extra and I have to delete it, now I do it manually). How can I delete that 25th row at once for all 92 people, so that I have 24 rows left for everyone?
Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.
Data sort and Deletion
I am having trouble sorting this dataset and then deleting some data. Column C lists unique ID numbers, and column D is the data collection date. This database allows us to track data over time. However, I am working on a dashboard and only want to display the most recent data. For each collection data, there are 6 possible disability answers. I need to keep the most recent 6 for each ID number and would like to delete the rest. Does anyone have a suggestion on if it is possible to do this with a formula or some other way?
Shorten to certain characters and perform IF formula
Good morning/afternoon/evening all I'm sure this is probably something simple I'm missing but I'm in a spot where I am trying to add a manufacturer indicator based upon the first three characters of data, such as what is below: Basically, I'd like to remove the "Make" column. Currently I'm using a simple =LEFT(VINcell,3) to shorten it, and then =IF(MAKEcell="1GB","Chevrolet","GMC"). I'm probably missing something simple or it's not possible, but many thanks in advance!Conditional Formatting Formula
I am trying to create a formula for conditional formatting to check that if two individuals have the same day off and neither have coverage, then the rows for those two highlight red. If one does find coverage then the rows stop highlighting. So in the below example, John and Sarah both have 4/24 and 4/25 off; but Sarah found coverage for the 25th. So I would want the rows for 4/24 to be highlighted and the rows for 4/25 to NOT be highlighted.Comands not visible under some tabs unless I select arrow
The Alignment tab does not display the various commands like wrap text unless I select the arrow under alignment. I found that I am supposed to have a “Ribbon Display Options” arrow in the upper right corner of Excel, but I do not have this arrow. How do I restore this arrow? This is also true of the Number tab.Look Up for multiple sheets?
I wonder if someone would be so kind as to help me with a little problem... I have 12 different workbooks, one for each store, for labour and sales forecasting. On each workbook there are a few different sheets - one for each period and then a final sheet which shows the total for each week and period, giving a quarterly summary. The only problem with this is when I want to review these I have to open individually 12 different workbooks. Is there a way that I can create a new workbook, which shows the 'Quarterly Summary' page for each store. I initially thought a look up formula, but I think this only applies to particular cells and not an entire sheets? Thanks in advance!Conditional Formatting code help
I have 300o rows that I need code in, is there a faster way to write this so I don't have to write a policy rule for each row? What I need to accomplish: If "Dismissed" is selected in Column C I need it to turn Cells A,B, & C in that row Yellow but only that row. Above is the only way I can think to do it but then I would have to basically copy and change the row # from Cell 3 to 3003 and boy I'd really like to avoid having to spend the time doing that. I'm sure there is a way to do this in a much simpler faster way, I just can't think of how to get it done other than the way I don't want to do it.
Find and replace mystery
I am attempting to replace all the occurrences of "$23" within a formula with "$43" [I'm not using the quote marks in the box]. Every single time, it replaces it with "$34" instead of "$43". For troubleshooting, I tried: Find "23" replace with "43" - it worked correctly. Find "$23" replace with "$6300" just to see if a different 'replace with' value would have a different outcome - it still replaces it with "$34" I have another find and replace in the same cell and same formula where I am replacing "$18" with "$38" - it works just fine! I do not have the SUBSTITUTE formula anywhere in this cell. I read somewhere that SUBSTITUTE could affect find and replace. I am stumped. If it matters, the "$23" I am trying to replace is within a SUMPRODUCT formula. I am using 365.
count some data
Hello My friend, Can anyone please inform me what is the Excel equation for the below details: I have 2 columns first one the state and it have two cells only with C or T....and the second column is for agent name which has many cells more than 3k...so i need to know like the cells on the right every agent how many total it have of c and t and how many separately. Thanks in advance.
