inconsistent

So... basicly what the title says. I have a formula which lets me filter values from a huge table as a database. the formula is as follows: =LET(Advanced, IFS(F2<>"",SEARCH(F2,'Verbrauchsmaterialien Datenbank (work in...

Hello~ This is driving me insane. Any help would be greatly appreciated. I have an MS Access Application that runs a relatively complex process of extracting data from certain Excel workbooks, performing several calculations, and then populating the results of the calculations in another...

I'm trying to solve a problem to automate the formatting of some inconsistent source data we download daily for a partner. The source data is formatted like below. For the all lines we need to pull data into a simplified table. Ex. first line we need to pull the invoice # (11753195), Vendor...

Hi everyone, Is it possible to count the number of dashes in a string that do not have space on both or just one side? The string length will be inconsistent so cannot use number of words. e.g. "This-document" would be counted, whereas "This - Document" would not. Thanks!

I have a sheet called ROPdata that looks up matching values from another sheet in order to create a graph. ROPdata <tbody>#cacaca[/URL] "] B C D #cacaca[/URL] , align: center"]1 Depth ROP (min/m) Gas (%) #cacaca[/URL] , align: center"]2 400.0 0.1 2.0 #cacaca[/URL] , align: center"]3...

Hi MrExcel, I am having problems with the auto-page breaks on a classic pivot table (see attached picture). When items from the inner field (Dimension 2) overlap a page such that only one item is showing on the second page, then the auto-page-break does not work, resulting in the next item...

I have a index/match formula that returns the contents of a cell from the prior month, however it's only working about 80% of the time. I have 21 rows with the formula referencing corresponding worksheets. About 11 of them reference 2 months prior vs 1 month prior...

In cell I14 i have typed "=H14+E14" and Excel is warning me this fomula is not consistent with other formulas in this area. YES it is not supose to be Consistent with other formulas in this area. Can I turn off this feature globally or do I have to click on the "!" and tell each cell...