Column of dates from an exported report. In the pivot, right click, Group is greyed out for the date field, and the rows show every single day as its own line. If I type a date manually into a blank cell it looks…
Roughly 8,000 rows, 15 columns, mostly SUMIFS with a few INDEX MATCH and some conditional formatting. Every time I type in a cell the whole thing freezes for about 20 seconds. The file is only 4 MB. Is this normal at…
Bank export, about 12,000 rows. Amounts came in as text with thousands separators, and SUM ignores the column entirely. Multiplying by 1 gives VALUE errors on some rows. There is also something odd where negatives…
Inherited a workbook with one sheet per month going back three and a half years, identical layout, about 800 rows each. I need totals by category by month and eventually a chart. Do I keep the structure and write SUMIFS…
Lookup value is an order number like 100234, sitting in column A on both sheets. returns N/A for about a third of the rows and works perfectly for the rest. If I copy the value from one sheet and paste it into the…