Need help writing UDF to determine the Row number of a value

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need help writing UDF to determine the Row number of a value

FAQ

Thread Tools

Display Modes

08-05-2022, 07:42 PM

soroush.kalantari soroush.kalantari is offline

Windows 10 Need help writing UDF to determine the Row number of a value

Office 2016

Competent Performer

Join Date: Jun 2021

Posts: 124

soroush.kalantari is on a distinguished road

Quote:

Originally Posted by Pecoflyer

If I understand correctly this can be easily solved without VBA or UDF with a simple SUMPRODUCT function

See attached

Yes. you are right. This problem can be solved with your approach without VBA. I didn’t understand the sumproduct can be used in such ways.
No. I didn’t understand the way you mention to thank to somebody to help me. Thank you very much for all the points.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to determine if a Section number has a field code	scienceguy	Word VBA	8	11-11-2021 05:19 AM
Word writing {PAGE} instead of inserting page number	Johanna	Word	5	07-04-2019 07:56 AM
Determine if a cell contains a 0 value	bgranzow	Word VBA	1	01-07-2016 03:50 PM
Is there a way programmatically to determine the footnote number style, if other than arabic numbers	gn4619	Word VBA	2	11-23-2015 11:00 PM
Edit number of characters per page after writing whole paper	dea	Word	1	01-04-2011 02:24 AM