-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
aproximate
-
S
Approximate match in power query
Hello everyone, I have 2 columns in power query. I want to assign the best approximation to column 1 from column 2 For example: For the phrase column 1 https://www.screencast.com/t/KafThnRPS Best match is https://www.screencast.com/t/CZiJINVA20v in column 1 can be from 1 to 4 words compatible...- secriera
- Thread
- aproximate excel lenjerie match power query
- Replies: 0
- Forum: Power Tools
-
I
Sumproduct with dynamic array
Hello to every one, Ioan here I don't succeed to create dynamic array for range of cells, this dynamic aaray will be usefull to aproximate a specific value: Please watch the image to understand what i want to say https://imgur.com/a/4vQHP Thank's- IoanZ
- Thread
- aproximate array dynamic usefull watch
- Replies: 3
- Forum: Excel Questions
-
M
RANK using an approximate value match.
I am using RANK but because the values in the Range are calculated the number that I am trying to determine the rank of does not match. Is there a way of doing an approximate match using the rank function. I tried FLOOR but that did not eliminate my problem. Thanks, Michael- Mike Slattery
- Thread
- aproximate rank
- Replies: 2
- Forum: Excel Questions
Understanding data is crucial, and the easiest place to start is with Microsoft Excel.
This Week's Hot Topics
-
link pictures from Sharepoint to Excel macro
- Started by jc83ph
- Replies: 35
Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to... -
lookup match return closest to x date
- Started by 288enzo
- Replies: 35
Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It... -
Average hours per week
- Started by rgillson3
- Replies: 31
I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date... -
Google Sheets IMAGE Function
- Started by excelbytes
- Replies: 30
Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google... -
Identify equipment used -No of consecutive days
- Started by ABC1
- Replies: 26
Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset... -
Filling in data from source
- Started by Luke777
- Replies: 26
Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...
