python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - excel-2010

how can find user id of max number that we have Find by using Max Command

let we have a table , in table we have number of transaction by user so we can find max transaction by user using MAX or LARGE Command in Excel , SO my question is that if we find Max transaction by...
test-img

Usɱʌn ʌʜɱʌd Ƴoʋsʌʆxai

excel

excel-2010

export-to-excel

Votes: 0

Answers: 1

Latest Answer

You can do this in many ways: F3 formula is: =SUMPRODUCT(--(A2:A8=MAX(A2:A8))*B2:B8) F4 formula is @SolarMike suggestion: =INDEX(B2:B8;MATCH(MAX(A2:A8);A2:A8;0)) A third option would be using Pivot T...
test-img

Foxfire And Burns And Burns

VLOOKUP retrieving data under today's month and year

So my problem is that I cannot figure out how to use VLOOKUP to get data under today's month and year. So as seen in the pic, I have data under every month of multiple years and I need to look up the...
test-img

YSWS

excel

excel-formula

match

excel-2010

vlookup

Votes: 0

Answers: 1

Latest Answer

I think that the HLOOKUP function is probably called for here: =HLOOKUP(TEXT(TODAY(), "MMM-YY"), Sheet2!B6:AD16, 2, FALSE) I'm also not sure about using semicolons in formulas like you've ...
test-img

Pat Jones

How to combine different strings of text for each unique ID into 1 line for each ID

The image below shows the example table of data I have (columns A to B), and the table on the right (columns e to f) shows my desired output. I just don't know where to start with this one, as I need ...
test-img

BradleyS

vba

excel-2010

Votes: 0

Answers: 3

Latest Answer

Combine Unique and Delimited Data Using a Dictionary of Dictionaries Option Explicit Sub CombineData() ' Source Const sName As String = "Sheet1" Const sDelimiter As String ...
test-img

VBasic2008

Check empty cells and if specific cells in same row has data then assign a value for those empty cells

I've been wondering if there's a VBA method to fill in empty cells if only some cells in the same row have data. as in the screenshot, i want empty cells in column D to be filled with eg "missing...
test-img

DesTro

excel

vba

excel-formula

excel-2010

Votes: 0

Answers: 1

Latest Answer

You were quite close, You need to loop via main column in question. the Application.Sum(Range("A" & i & ":C" & i)) <> 0 sums the range (Ai:Bi) during the loop. &a...
test-img

NoobVB

Posts

Questions

Blogs

Jobs