-
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.
name]
-
Array Formula problem in VBA
Hi all When I enter the following formula manually (with Ctrl+Shift+Enter) it works fine: =INDEX(tbl_List[Referral Name], MAX((tbl_List[Intake Rep]=B2)*(tbl_List[Clean Doc Count]=MAX(IF(tbl_List[Intake Rep]=B2, IF(tbl_List[Clean Doc %]=MIN(IF(tbl_List[Intake Rep]=B2, tbl_List[Clean Doc %]))...- iggydarsa
- Thread
- %]=miniftbl_list[intake doc name] rep]=b2 tbl_list[clean
- Replies: 3
- Forum: Excel Questions
-
L
Return Latest Value Matching Invoice Number
Hi, Can someone please come up with a formula to put the latest Invoice Total in F10 matching INV number in A10 on the Status sheet. The data is in the Lookup Invoice sheet. Thank you Excel WorkbookJKL2Invoice TotalsInvoice NumberTime...- Legacy 436357
- Thread
- excel id]] invoice name] table4[cust
- Replies: 3
- Forum: Excel Questions
-
B
Print: "In-Stock", or "No-Stock", IF Multiple Conditions Are Met
I'm back, with another headache haha. I have 2 Sheets. Sheet 1 - Is user-friendly Sheet 2 - Is a database full of product information. Sheet 1 currently looks like... <tbody> A B 1 [In Stock?] [Product Name] 2 ? Product #3 3 ? Product #2 4 ? Product #4 5 ? Product #1 </tbody>...- BrandonBerner
- Thread
- name] product sheet stock [product
- Replies: 5
- Forum: Excel Questions
-
E
VBA MsgBox Query
When I'm entering a Message Box in VBA, you have to enter a prompt as string, i was wondering if it possible to reference another cell within the string? i.e. MsgBox("Employee [insert name] has two shifts scheduled for this day") where the employee's name is located in the same worksheet- EwEn999
- Thread
- msgboxemployee name] string vba [insert
- Replies: 2
- Forum: Excel Questions
-
S
Cross filtered tables - pivot with dimensions from multiple DIM tables
Hi I have a question wrt to an existing thread: https://www.mrexcel.com/forum/power-bi/1064965-dax-cross-filtering.html The diagram below shows the model and the solution was: [# Contracts] = CALCULATE ( COUNTROWS ( Contracts ), SuppliersProducts ) = This all works fine but my issue is...- serky
- Thread
- contracts] data name] product suppliers
- Replies: 1
- Forum: Power Tools
-
B
Same measure evaluates differently in Excel 2013 and Excel 2016
The following measure produces a different result depending on whether I use a machine with Excel 2013 or Excel 2016: =FIRSTNONBLANK(Russell_Group[Provider short name], IF( [Research Income (Total) £k] = CALCULATE([Benchmark (Research Income £k)], VALUES(...- btreg
- Thread
- excel income measure name] short
- Replies: 0
- Forum: Power Tools
