I need help with writing an Excel formula.

Jans Marteno · 10. März 2024

I have 8 rows. The 1st row is in the range A14:H14, the 2nd row is in A15:H15, the 3rd row is in A16:H16, the 4th row is in A17:H17, the 5th row is in A18:H18, the 6th row is in A19:H19, the 7th row is in A20:H20, the 8th row is in A21:H21. In the range H14:H21, there are numbers. Each row has one of the 8 numbers. I need a formula that will find the largest number and automatically copy the row in which this number is located to the range A22:H22. And the most important thing is that if I change the numbers and the biggest number is moved into another row, the new row in which the number is n

Jen__L

Hi DavidSchriever,

Yes, it's possible but I would need to see your data so I can help you with the formula. Thank you.

Kind Regards.

Thomas_20018

Hey Kev, thanks for your answer.
Could you tell me the formula that i need for my problem?

Thank you in advance, Thomas.
<br />

MKaiser82

How does ODBC with Excel work under Windows 7 without running Excel as Administrator?

Using Windows XP I didn't need to have admin rights to configure ODBC connections and as well none to use these ODBC connections e.g. in Excel 2010.

Now using Windows 7 I need admin rights to configure ODBC - that's okay. But I also need them to connect via ODBC to my database. When I don't run Excel as admin, the connection doesn't start (there is even no message why not) - I need to start Excel as admin
each time.

Is there no way to use ODBC without starting Excel as administrator? (I would be ok, when the admin password prompt appears when I try to connect to my ODBC data source... but this doesn't happen)...

The main problem why I can't default to run Excel as administrator: I cannot open any Excel-Document e.g. out of the Windows Explorer with Excel. I always have to start Excel first and then use the File-Open-Dialogue to access the Excel sheet.

Information:

I use an IBM ODBC driver for DB2 and Excel 2010, Windows 7 SP1

Puma5000

Das war ja wieder ein Treffer ins Schwarze - Danke

Habe das ActiveCell.Offset(, 10).Formula durch ein ersetzt.

Range("h1").Formula = "=IF(AND(A1="""",B1=""""),C1+D1,IF(A1<>"""",A1,IF(B1<>"""",B1)))"

Funktioniert!!!

Was muss ich machen um

h1 oder alle variablen mit einem Zähler zu versehen für die entsprechenden Spalten

Sub Makro1()

'

' Makro1 Makro

With Worksheets("Tabelle1")

i = 1

Range("h" & "i").Formula = "=IF(AND(A1="""",B1=""""),C1+D1,IF(A1<>"""",A1,IF(B1<>"""",B1)))"

i = i + 1

End With

End Sub

Andreas Killer

https://support.microsoft.com/de-de/help/211967/chart-trendline-formula-is-inaccurate-in-excel

Hi,

willkommen im Windows Forum!

I need help with writing an Excel formula. - Similar Threads - need help with	Forum	Datum
Need help with BSOD Need help with BSOD: Details:WIndows 11 ProRyzen 5700g IGPU newest driverAll chipset drivers are up to dateBoard: A520 M-A PROBios Version: 1.I0 26.7.2024Ram: 32GB 3200mhz DualPc is new and had crashes before related...	Apps	27. März 2025
Need help with BSOD Need help with BSOD: Details:WIndows 11 ProRyzen 5700g IGPU newest driverAll chipset drivers are up to dateBoard: A520 M-A PROBios Version: 1.I0 26.7.2024Ram: 32GB 3200mhz DualPc is new and had crashes before related...	Games und Spiele	27. März 2025
Hi i really need help with thins audio Hi i really need help with thins audio: So i was using my headphones and turned them of and on again. now i cant find them in the output device section. The input device head set mircophone is there but the output device is not...	Apps	31. Dezember 2024
Hi i really need help with thins audio Hi i really need help with thins audio: So i was using my headphones and turned them of and on again. now i cant find them in the output device section. The input device head set mircophone is there but the output device is not...	Games und Spiele	31. Dezember 2024
I need help with MS 365 WORD ONLINE. I need help with MS 365 WORD ONLINE.: Dear MS Community,Please call me at 49-261-33309. The Microsoft Help team is not trained on MS 365 ONLINE. The help team gave up after 90 minutes.I need help regarding MS 365 WORD ONLINE. The...	Microsoft Office	27. Dezember 2023
Hello, i need help with my PC Hello, i need help with my PC: Around 2 days ago i disabled some sort of setting, making it, that only essential program open on startupAfter rebooting, my audiodrivers dont work anymore, and the diagnostics dont recognise the...	Apps	23. Juni 2023
Hello, i need help with my PC Hello, i need help with my PC: Around 2 days ago i disabled some sort of setting, making it, that only essential program open on startupAfter rebooting, my audiodrivers dont work anymore, and the diagnostics dont recognise the...	Games und Spiele	23. Juni 2023

I need help with writing an Excel formula.

I need help with writing an Excel formula.

Select from Dropdown menu if certain value is in another field

Excel Formel zum Datum einfärben

Wie funktioniert ODBC in Excel unter Windows 7 ohne Excel als Administrator zu starten?

VBA Formeln per Makro in Zellen schreiben

Mehrere Nachkommastellen angeben

User Advert

I need help with writing an Excel formula. - Microsoft Office

I need help with writing an Excel formula. - Similar Threads - need help with

Need help with BSOD

Need help with BSOD

Hi i really need help with thins audio

Hi i really need help with thins audio

I need help with MS 365 WORD ONLINE.

Hello, i need help with my PC

Hello, i need help with my PC

I need help with writing an Excel formula. solved