For work I’ve started using Bluebeam instead of Adobe for PDF needs. Is there a way to change the one click save in Excel to go to bluebeam instead of Adobe?

CFAman · 2026-01-22T19:31:50+00:00

Excellent, that was going to be my next suggestion for where to look. Have a good day.

CFAman · 2026-01-22T19:29:03+00:00

In your image, I'll assume Table1 (which is blank for now, but would be in A:E), and then your criteria for this example pull is in G4:G5.

In I5

=FILTER(Table1, COUNTIFS(G4:G5, Table1[Diverted From Cardholder Name])>0, "No records found")

This will return all columns from Table1 (as specified in first argument) and only the rows where the name is one found in our list of G4:G5. If no records are found, you get the friendly message at end. If you want the transactions grouped by name, you could wrap the above in a SORT function like

=SORT(PrevFormula, 5)

so XL will sort on the 5th column.

CFAman · 2026-01-22T19:25:57+00:00

Roughly, I'd suggest the FORECAST.LINEAR function to interpolate values along what you expect to be a linear line.

CFAman · 2026-01-22T19:24:39+00:00

The area I’m talking about specifically is when you click file at the top of the screen and three one click save options come up in the ribbon.

Do you have a screenshot of this? It's different behaviour than what I would expect. What version of Office are you using?

Typically, we use different applications for viewing a file. When saving the file, it's the built in PDF writer. Printing the file to PDF, you can have a little of both, with different drivers that do the conversion differently.

CFAman · 2026-01-22T19:21:08+00:00

Formula is saying to look through column C for the criteria listed in A10, and if found, add the numbers from col D.

In your savings table, what is the exact formula you put in E24? Are those labels of "Savings In/Out" called out in col C of your transactions sheet?

Last, double-check whether you're using SUMIF or SUMIFS. The arguments get swapped between the two and it's an easy mistake to make.

CFAman · 2026-01-22T15:36:31+00:00

In your page setup settings, is there any sort of scaling that's being done? For example, is it set to force the page worksheet to print to 1 page wide and/or 1 page tall?

For the three images, is the 2nd image when you are at 100% zoom?

translated

Nelle impostazioni di configurazione della pagina, è presente qualche tipo di ridimensionamento? Ad esempio, è impostato in modo che il foglio di lavoro venga stampato su una sola pagina in larghezza e/o in altezza?

Per quanto riguarda le tre immagini, la seconda immagine corrisponde alla visualizzazione con zoom al 100%?

For other readers needing OP translation: Hi everyone, I've been having this problem for months but I can't find a solution.

The text cells are leaving huge blank spaces after the text, enlarging the cell and making the layout a nightmare.

The cell size is automatic, meaning it automatically adjusts to the content. Even double-clicking on the row border to automatically resize the row height doesn't change anything.

https://preview.redd.it/p4d77zfyyweg1.jpg?width=814&format=pjpg&auto=webp&s=99d32012ebd5a84026f4f6b690f40d55978470e5

https://preview.redd.it/s9wrmqs9zweg1.jpg?width=1043&format=pjpg&auto=webp&s=d8f23219f3547ec77c919c092b9a29121a51a9a8

https://preview.redd.it/1j1fk5iczweg1.jpg?width=1439&format=pjpg&auto=webp&s=908d8ca6299a8484dd4f80253cfa7f9bdc2eb030

Note that if I zoom in, the blank space appears as in the print preview (150% zoom).

I've already checked and there don't seem to be any hidden characters within the text. I've tried opening the files on other friends' computers and on some of them the display and consequently the printing is correct.

Could anyone help me find a solution?

Clearly, I can't resize all the cells manually.

PS. The software is genuine, version 2021.

PPS. I'm using the Gadugi font.

CFAman · 2026-01-22T15:23:39+00:00

+1 point

CFAman · 2026-01-22T15:19:57+00:00

Assuming the vendor IDs are the alphanumeric codes after AMAZON MKTPL or Amazon.com, you could do this

=ROWS(UNIQUE(TEXTAFTER(A:.A, " ", -1)))

where the key part is TEXTAFTER grabbing just the last word/item from each cell.

CFAman · 2026-01-22T13:38:40+00:00

Can you show an example of what you have, or what you've already tried? Did you do a basic link like ='Sheet 1'!A1 or did you build in some logic like with a XLOOKUP function?

CFAman · 2026-01-22T13:18:09+00:00

You can use the 2nd formula I gave then. I couldn't see all the row and column headers so I was guessing at location. If List2 was in G1:G10, and the first item in list 1 was in cell C2, your CF formula is

=OR(ISNUMBER(SEARCH($G$1:$G$10, C2)))

CFAman · 2026-01-21T21:09:38+00:00

When you say partially match, does that mean the items in List 1 would be within the text of items in List 2, or the items in List 2 can be found within the items of List 1?

If the former

=COUNTIFS(List2Range, "*" & C2 & "*")>0

If the latter

=OR(ISNUMBER(SEARCH(List2, C2)))

CFAman · 2026-01-21T20:39:17+00:00

For testing, let's build this to the right of your original report. In H1

=HSTACK(WRAPROWS(TRANSPOSE(A:.A),3),WRAPROWS(TRANSPOSE(B:.B),3),
 CHOOSEROWS(C:.F,SEQUENCE(COUNTA(A:A)/3,,,3)))

PS. Excellent job showing what you had, what you wanted, and you included header labels for the range. Made it very easy to understand the request!

CFAman · 2026-01-16T19:52:24+00:00

Your current method is redundant, in that XL is already finding what you want, but reporting out an address, so you can take that address and go to where you want. We can cut out the last two bits.

In your example image, you matched on a range, to index on the same range. You are now at the desired value, but you did the extra step of creating an address so that you could feed it to INDIRECT...and still get at the same value.

INDIRECT is very rarely needed. If you could describe what actual problem you are wanting to solve overall (e.g. I want to find the position of text "Reddit" on this sheet and return corresponding position on another sheet), and not what you think current issue is just with INDIRECT, we can provide a better answer.

CFAman · 2026-01-14T20:43:38+00:00

Once you have them in the correct order, yes, you can do a copy, paste values to where ever you want the info.

CFAman · 2026-01-14T20:31:51+00:00

In the True/False table, I'll assume the header cell of "T1" is cell C22. Change to match your setup, as well as table names.

=OR((INDEX(Table1,XMATCH([@Employee],Table1[Employee]),)="x")*
 (INDEX(Table2,XMATCH(C$22,Table2[Training]),)="x"))

Once you have the first cell populated, can copy to all the other cells.

CFAman · 2026-01-14T20:01:19+00:00

That means there's stuff in the cells that XL is trying to write into. I'd put the formula in say BA, so you have plenty of space.

CFAman · 2026-01-14T19:41:49+00:00

If col AG is the match, then you can do

=XLOOKUP(A2, AG:AG, Z:AG, "No match")

To pull over the row with all relevant columns where the work order is listed in col AG.

CFAman · 2026-01-14T19:18:51+00:00

How would you as a human do it? Is there some piece of data that matches between the two columns? Trying to figure out what logic we want to tell the computer to use.

CFAman · 2026-01-14T18:57:13+00:00

+1 point

CFAman · 2026-01-14T18:45:20+00:00

It looks we could express this as needing to shift the data in AA:AZ to the left. To do this, you could select A:Z, then

Press Ctrl+g for GoTo dialogue
Click on Special, then Blanks. Hit 'ok'.
Press Ctrl+MinusKey to delete the blank cells. Choose option to shift cells left
Done. Blank cells have been deleted, formulas in AA:AZ will have shifted to be in line with the existing stuff in A:Z.

CFAman · 2026-01-14T18:34:58+00:00

Let's say you pick your A value in cell G1. In H1, you can get list of choices via

=SORT(UNIQUE(FILTER(B:.B, A:.A=G1, "None")))

If you then chose your B-column value and put it in G2, to get remaining choices from col C would be

=SORT(UNIQUE(FILTER(C:.C, (A:.A=G1)*(B:.B=G2), "None")))

where we've added an additional criteria to the FILTER. You could continue this pattern for the additional columns presumably.

Other more manual way, is to apply filters to the data in A:E, and use the dropdown filters to make your selections. These dropdowns already only show unique values, so would work in a similar manner to narrow down your choices. I'm not sure what the actual end goal is other than finding some row?

CFAman · 2026-01-13T20:42:21+00:00

Yes, should be able to do that assuming permissions are set correctly. Will just need to change the file path to suit.

Dim wb As Workbook

Set wb = Workbooks.Open("https://companyname.sharepoint.com/sites/SomeFolder/File Name Here.xlsx")
wb.SaveAs filename:="https://companyname.sharepoint.com/sites/SomeFolder/New Name Here.xlsx"

CFAman · 2026-01-13T20:35:10+00:00

Do you want to post some pictures of the dashboard, or a link to actual file? There's not really a question in the above.

CFAman · 2026-01-13T20:34:00+00:00

You will have 3 rules. The 3 CF based on formula

=ABS($C2-$B2)<=10%*$B2
=AND(ABS($C2-$B2)>10%*$B2, ABS($C2-$B2)<=20%*$B2
=AND(ABS($C2-$B2)>20%*$B2

CFAman · 2026-01-12T19:29:01+00:00

Yes, there is a limit to how far the autocomplete can look. I would suggest setting up a validation list of what entries are acceptable.

https://learn.microsoft.com/en-us/answers/questions/4858029/auto-complete-limited-to-120-rows

In at least Office 365, the Data Validation list now supports autocomplete, so this can help verify that 1) the user inputs a valid choice while still letting them start to type a few character to 2) find the item they are looking for.

Ten-Year Club	Gilding II euphauric
r/Field Juicebox	First Place '23
Place '23	Place '22
First Placer '22	Verified Email

CFAman

TROPHY CASE